Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Employee
Employee

Monthly comparison with previous month

Hi i have a straight table with a month Year Field and count(Value) i then want to display another column which shows the varience of the count(value) with the count(value) for the previous month.

Please see attached excel spreadsheet..

I can hardcode in 12 months into a straight table with the varience but is there a more dynamic way of doing this?

1 Solution

Accepted Solutions
daveamz01
Contributor III

Re: Monthly comparison with previous month

Hi nam,

yes, it is, with above() function.

Regards,

David

2 Replies
daveamz01
Contributor III

Re: Monthly comparison with previous month

Hi nam,

yes, it is, with above() function.

Regards,

David

Employee
Employee

Re: Monthly comparison with previous month

Thanks.. Im having a dull moment today