Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Firms
Contributor
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.

Labels (2)
0 Replies