topic Exluded Function in QlikView

Exluded Function

suzel404 — Sat, 14 May 2016 13:15:05 GMT

Hi all,

I want to calculate the number of ID without TYPE_ID = 4 like this : Count(DISTINCT {<ID= E({<TYPE_ID={4}>} ID)>} ID)

But when I select an ID : 20133663 normally I have to see the unique selection but I cannot display it in the straight table.

Thanks for your help,

Regards

sunny_talwar — Sat, 14 May 2016 13:22:29 GMT

Try this:

=Count(DISTINCT {<ID *= E({<TYPE_ID={4}>} ID)>} ID)

suzel404 — Sat, 14 May 2016 21:24:19 GMT

Thanks you Sunny

It works fine !!