Set analysis

[bellesol]

Hi,

can anyone explain the following set analysis:

sum({<[%Month Num]={"<$(=num(Month(Today())))"},[Year Diff]={'-2'}>}[Sales])

It's supposed to calculate the sum from the beginning of the year until privies month (meaning from Januar until December 2018 )

This set analysis worked fine until last month, meaning it calculated the sales from January until November, but now it's not working. how can I fix it?

Month	%Month Num	Year	Year Diff
Jan	1	2019	-1
Feb	2	2019	-1
Mar	3	2019	-1
Apr	4	2019	-1
May	5	2019	-1
Jun	6	2019	-1
Jul	7	2019	-1
Aug	8	2019	-1
Sep	9	2019	-1
Oct	10	2019	-1
Nov	11	2019	-1
Dec	12	2019	-1
Jan	1	2018	-2
Feb	2	2018	-2
Mar	3	2018	-2
Apr	4	2018	-2
May	5	2018	-2
Jun	6	2018	-2
Jul	7	2018	-2
Aug	8	2018	-2
Sep	9	2018	-2
Oct	10	2018	-2
Nov	11	2018	-2
Dec	12	2018	-2

[Brett_Bleess]

Hey Bellosol, did you get things working or are you still stuck?  Just wanted to be sure you circled back if something someone posted did help to mark that post using the Accept as Solution so they get credit and the other Community folks know what worked.  

I was thinking of something someone posted recently related to things at year end, but I cannot recall what the setting was he mentioned to change the behavior, as this is almost what things sound like.  I just remembered what it was:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Numbe...

Maybe that will be of some help potentially if you are still working on things.

Regards,
Brett