Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Previous Month with Month as dimension

Hi everybody,

I want to know if this is possible with a Set Analysis to make an expression giving the previous month when the field month is a dimension of my chart ?

Here the Set Modifier would be dynamic and specific for each months ?

Solving this problem would help me to calculate the variation between months.

I don't want to modify the model with the script by placing the value of the previous month on each corresponding row.

Is there somebody who have a solution for this ?

Thanks,

Vincent

PS : I attached an application trying to illustrate my problem

1 Solution

Accepted Solutions
MayilVahanan

HI

PFA

Use before() function.

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

HI

PFA

Use before() function.

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
silvia_assuncao
Creator
Creator

Hi pretty cool what you did here. but what if I want to have the variance result in a line chart? I tried to change this to a bar chart, but it when I do this change all the information goes blank.

Thanks and best regards,