Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
DataKnight1
Contributor III
Contributor III

Show daily movements between dates

Hi,

This feels like something that should be straight forward, but I'm hitting a brick wall!

I have a pivot table.  I have a dimension which is a date.  I have an expression which gives me a count of something (so my result is a count of something across date) - all good.

So let's assume my pivot table looks like the below;

01/08/2022          02/08/2022          03/08/2022          04/08/2022

     100                           200                          250                           150

I want to show the daily movements on a new row as;

       -                               100                          150                          -100

I thought that there would be a simple way to do this in expression?!  

Any help appreciated! 

Thanks all 🙂

Labels (4)
1 Reply
BrunPierre
Specialist II
Specialist II

@DataKnight1 Explain the logic behind your output.