Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Previous Month with Month as dimension

HI

PFA

Use before() function.

Hope it helps

2 Replies

Re: Previous Month with Month as dimension

HI

PFA

Use before() function.

Hope it helps

silvia_assuncao
Contributor

Re: Previous Month with Month as dimension

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,

Community Browser