sorting data in a straight chart

[0li5a3a]

Hi all,

I need your help. I have a straight chart  with 3 columns and  need to filter the data. EX

column 1               column 2                   column 3

123456                  abcd                         INDOOR

235466                  bbcs                         OUTDOR

23564                    abcd                       

I want to restrict the data just to be able to see the columns which contain the values INDOOR.

I want to restrict the data only in this specific chart not in the all appreciation.

Could you please suggest what I need to do?

Thank you in advance!

[sanjay006]

just suppress the null values

[0li5a3a]

I tried to add your code but Enable conditional doesn't works in this case...

Thanks 

[sanjay006]

In dimension tab select the dimension in which u don't want to see the null value and suppress.

[qlikview979]

Select Dimension

Click on  "suppress when value is null " in Dimensions Tab.

[0li5a3a]

Hi all,

I tried all of your advise and I found the following:

add this =only({<[Column 3]={'INDOOR'}>}[Column 3])

- like dimension nothing is changed

-  like  expression  you would see that not only the INDOOR columns, the nulls are too , if  you try to suppress zero values or suppress missing noting is changed

Thanks your your help

[qlikview979]

please share the app

[sanjay006]

Don't use this in enable condition use this as a dimension.

Add calculated dimension and use this .

[Anil_Babu_Samineni · Accepted solution]

Is this you are expecting? If not, You must share exact output need?

[0li5a3a]

your scenario is fine but my data is wrong

[sanjay006]

My scenario was not working ?