topic How to filter a column in QlikView

How to filter a column

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have one field named 'F/I' whose values are F,I

Now I put it into Table dimension, I don't want to show I in this dimension, how to filter it?

neelamsaroha157 — Tue, 07 Aug 2018 20:47:23 GMT

May be you can filter it out in your expression -

Something like -

Sum({<[F/I] = {'F'}>}YourMeasureField)

vishsaggi — Tue, 07 Aug 2018 21:04:26 GMT

Or you can try like in your calculated dimension

= Aggr(IF([F/I] = 'F', [F/I]), [F/I])

pooja_prabhu_n — Wed, 08 Aug 2018 07:25:16 GMT

Hi,

try this in calculated dimension and check suppress null value

IF([F/I] = 'F', [F/I])

Thanks,

Pooja