Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

satishkamath
Contributor II

Present month and previous month difference

Hi All

I need difference on current cell as below

Requirement is

                    Jan-2012  Feb-2012  Mar-2012  Apr-2012   --- so on

Customer 1       0             -800           -320       110       ---------so on

Customer 2       0              520           -470      -1090     -------- so on

Meaning current month value - previous month value

I have attached test.qvw

I appreciate your suggestions

Thanks

2 Replies
MVP
MVP

Re: Present month and previous month difference

Expression: =Alt(sum(InvoiceValue) - before(total sum(InvoiceValue)), 0)

Turn off "Suppress Zero Values"

(tested on your model)

Capture.PNG

satishkamath
Contributor II

Re: Present month and previous month difference

Hi Jonathan

It's works. I appreciate your help.

Thanks

Community Browser