Can you please provide more clarification on what you want to do?
@ Kashish As you can see that there are 4 options in that filter i.e. Null,District Hospitals,Medical Colleges and Trauma Centre. All i want is to display null values all the time without its option.So either i hide the null option or do calculation so that it displays null values all the time.
The values are coming from black spots. Which i want to display all time but without displaying its option
You can do it using parameters instead quick filter but using parameters you loose multiple selection option.
Is this ok to you?
Well that is indeed my problem, the client wants multiple selection as well as those black spots(null values) default without its option. Is it even possible???
I think there is problem in my calculation can you check it up for me
I am afraid I don't know how to do this. Maybe Luciano would be able to help you.
@ Kashish Thanks for making an effort
I believe is no possible to do using Quick filters.
You can group information but nulls in this case would be added in others values. It doesn't seems correct to me.
Null is a value on your data. This is not a Tableau problem. You need to treat befoe.
Well i want black spot values(null values) at default, By default i mean. There should be 3 options in that quick filter i.e. District Hospitals, Trauma Centre and Medical Colleges. When user checks District Hospitals checkbox it should display data of District centres and Black Spots(null Values), and same thing goes for Medical Colleges and trauma Centre.
I need to make them mutually exclusive.
IF NOT ISNULL([Name DH]) OR NOT ISNULL([Black spot]) AND ISNULL([Name MC]) AND ISNULL([Name TC]) THEN
ELSEIF NOT ISNULL([Name MC]) OR NOT ISNULL([Black spot]) AND ISNULL([Name DH]) AND ISNULL([Name TC]) THEN
ELSEIF NOT ISNULL([Name TC]) OR NOT ISNULL([Black spot]) AND ISNULL([Name DH]) AND ISNULL([Name MC]) THEN
This is the calculation that i'm using, When i'm selecting District Hospitals it is showing data of district hospitals and black spots(null Values). But when i'm choosing Trauma Centre and Medical Colleges it is only showing there respective data.
So i need to make this condition mutually exclusive, can anybody help me with this calculation.