topic Re: Alternate State in Set Analysis in QlikView

Alternate State in Set Analysis

Anonymous — Sat, 27 Aug 2016 22:05:54 GMT

Hi,

I have a table:

Year	Month	Invoice Number
2001	Jan	1
2001	Feb	2
2001	Mar	3
2001	Apr	4
2002	Feb	5
2002	Mar	6
2002	June	7
2002	May	8
2003	June	9
2003	July	10
2003	Aug	11
2003	Sep	12
2003	Feb	13

And I have the following expression in a Text box:

=Count({<Year={'2001'}>+<Month={'Feb'}>}DISTINCT [Invoice Number])

I thought the value would be 4+3=7 because Feb occurs 3 times. But the result is 6 (4+2). Why the expression ignores the Feb month in the year 2001? What is the logic behind that?

Thanks

Re: Alternate State in Set Analysis

sunny_talwar — Sat, 27 Aug 2016 22:27:52 GMT

May be this for double counting where Year = 2001 and Month = Feb. For double counting that row, you can do like this:

RangeSum(Count({<Year={'2001'}>}DISTINCT [Invoice Number]),

Count({<Month={'Feb'}>}DISTINCT [Invoice Number]))

Re: Alternate State in Set Analysis

Anonymous — Sun, 28 Aug 2016 00:38:15 GMT

Thanks Sunny for your reply. I got it

Re: Alternate State in Set Analysis

sunny_talwar — Sun, 28 Aug 2016 00:50:51 GMT

Awesome, if my response helped you get to what you wanted help with, then mark it as correct response, or if it was something else that helped you please provide the details of what did help as it might help some one else in the future as well.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny