Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
Firms
New Contributor

creating a pivot that documents monthly differences

Hi,

I am rather new to Qlikview,  and I am trying to document a monthly changes to a subtotal via a pivot.

For Example

Capture.JPG

I really want to achieve a second row documenting the difference between the monthly columns. So, under February, I would see -7,518 and under March; -2,843 etc... Obviously January will be NULL (but I can live with that).

The only way I can think about doing this is in a separate pivot, but I wouldn't even have a clue where to start with an expression to make this work.

 

Any thoughts would be greatly appreciated.