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!

[qlikview979]

Not sure

are you expecting to  show straight table only 'INDOOR' right .

[0li5a3a]

yes please

[0li5a3a]

I tried to use IF and ONLY but I can't restrict the data....

[qlikview979]

try this

[tresesco]

If there is any aggregation function (min, max, sum, count....) you are using in the chart, you can use set analysis to restrict the output like:

Sum({<FieldName={'INDOOR'}>} Sales)

Now, change it to your context.

[qlikview979]

you try like this also

with only() function

only({<[column 3]={'INDOOR'}>}[column 3])

[sanjay006]

[sanjay006]

=if(WildMatch(column 3,'INDOOR'),column 3)

if u want in your dimension.

and if u want it in value

Sum({<column 3,={'INDOOR'}>} value)

[0li5a3a]

I tried your code but I have a problem with the nulls.  How I can exclude nulls?