CALENDAR MEASURE AND PREVIOUS YEAR

[philgood34]

Let me explain my issue with a example (app joined)

I have 3 years with CATTC (sales if you prefer) each month

i want to compare for each month :

     évolution CATTC of the year Vs prévious year

&

     gap between CATTC of the year and goal (goals are datas in a table ) (here is not my issues)

well i did that after created a calendar measure with CATTC

I have 2 issues in my visualization :

if i select only 2016, sum cattc YTD = sum CATTC YTD last year as you see ??

Secondly

if i select 2017 ... there is no value in previous year

anyone have a idea ?

regards

PS : i have i another solution (thank's sunny) by script in another threads, but i want to progress using CALENDAR MEASURE

[sunny_talwar]

I have not checked the file, but check my response here:

Re: CALENDAR MEASURE YTD LAST YEAR QLIK SENSE