Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

philgood34
Contributor II

CALENDAR MEASURE AND PREVIOUS YEAR

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

expression.png

I have 2 issues in my visualization :

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

graph6.png

Secondly

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

graph7.png

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

1 Reply

Re: CALENDAR MEASURE AND PREVIOUS YEAR

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

Re: CALENDAR MEASURE YTD LAST YEAR QLIK SENSE

Community Browser