topic Set Analysis in QlikView

Set Analysis

tmumaw — Tue, 28 Nov 2017 19:45:56 GMT

Need a little help on set analysis and ignoring null values. Here is what I tried

Count({<Cont_Year -= {'-'},MGrp=>} total ServLoc)

It's giving me the total for both years and I need totals for 2017 and 2018 separately. Ignore the last column.

Here is what I am getting

Anil_Babu_Samineni — Wed, 29 Nov 2017 01:26:08 GMT

What if we can enable the option "Suppress" for MGrp ??

sunny_talwar — Wed, 29 Nov 2017 01:32:09 GMT

May be this

Count({<Cont_Year -= {'-'},MGrp=>} TOTAL <Cont_Year> ServLoc)

tmumaw — Wed, 29 Nov 2017 11:57:17 GMT

Thanks Sunny. I changed it to this and it worked. Your help is appreciated.

Count({<MGrp=>} TOTAL <Cont_Year> distinct ServLoc)