topic Re: Help in Completing this set analysis statement with an exclusion clause in QlikView

Help in Completing this set analysis statement with an exclusion clause

patrick_forbes — Mon, 24 Jul 2017 23:54:01 GMT

I need help with completing this statement. How do I combine these.

Currently, the below works to exclude a filter:

count ({<CalendarYear_PE = , CalendarQuarter_PE = >} MYKPI)

But I need to add this to "MYKPI" calculation so that everything works together.
count( {($<A={1}> +$<B={1}>)} DISTINCT(MYKPI))

Please help

Thanks

Re: Help in Completing this set analysis statement with an exclusion clause

Anil_Babu_Samineni — Tue, 25 Jul 2017 07:15:13 GMT

May be this?

Count({$<CalendarYear_PE = , CalendarQuarter_PE =, A = {'1'}> + <B = {'1'}>} DISTINCT MYKPI)

Re: Help in Completing this set analysis statement with an exclusion clause

Kushal_Chawda — Tue, 25 Jul 2017 07:34:06 GMT

may be like below

count( {<A={1},CalendarYear_PE = , CalendarQuarter_PE = > + <B={1},CalendarYear_PE = , CalendarQuarter_PE = >} DISTINCT(MYKPI))

Re: Help in Completing this set analysis statement with an exclusion clause

mangalsk — Tue, 25 Jul 2017 07:47:57 GMT

count( {($<A={1}> +$<B={1}>)} {<CalendarYear_PE = , CalendarQuarter_PE = >}DISTINCT(MYKPI))

Re: Help in Completing this set analysis statement with an exclusion clause

patrick_forbes — Tue, 25 Jul 2017 12:04:01 GMT

This one worked great! Yea guys, this one was tricky. Kushal demonstrated the exclusion piece to work by inserting it for A and separately for B.

Also Mangal's solution works but giving me slightly different results which I will have to test why to find out what's going on. My inclination is that 1 solution is giving me where A and B both have a 1, while the other is not.

Thanks guys, this is a great teaching tool!! Really appreciate it!

Re: Help in Completing this set analysis statement with an exclusion clause

Kushal_Chawda — Tue, 25 Jul 2017 12:26:16 GMT

Hi patrick.forbes

Thanks. Please mark the answer as correct or helpful so that everyone can refer to this if they have same problem

Re: Help in Completing this set analysis statement with an exclusion clause

patrick_forbes — Tue, 25 Jul 2017 12:28:55 GMT

This also works very well as a solution!