Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
apthansh
Contributor

Find diff between month to month Expense

Hi ,

I have data as below

Period                Expense           Period % Change


P9   2017             12,000

P10 2017             13,000

P11 2017             10,000

P12 2017             11,000

P1  2018              11,000

P2  2018              12,000

P3  2018              11,000

P4  2018              11,000

How to I find the Expense % Difference between 2 periods ?

Thank you much

1 Reply

Re: Find diff between month to month Expense

May be this

Expense/Above(Expense) - 1