Alternate State in Set Analysis

[Anonymous]

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

[sunny_talwar]

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]))

[Anonymous]

Thanks Sunny for your reply. I got it

[sunny_talwar]

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