https://community.qlik.com/t5/QlikView/Show-daily-movements-between-dates/m-p/1968958#M1220465 <P>Hi,</P> <P>This feels like something that should be straight forward, but I'm hitting a brick wall!</P> <P>I have a pivot table.&nbsp; I have a dimension which is a date.&nbsp; I have an expression which gives me a count of something (so my result is a count of something across date) - all good.</P> <P>So let's assume my pivot table looks like the below;</P> <P>01/08/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02/08/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03/08/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 04/08/2022</P> <P>&nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 250&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;150</P> <P>I want to show the daily movements on a new row as;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 150&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -100</P> <P>I thought that there would be a simple way to do this in expression?!&nbsp;&nbsp;</P> <P>Any help appreciated!&nbsp;</P> <P>Thanks all <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 16 Aug 2022 06:35:03 GMT DataKnight1 2022-08-16T06:35:03Z https://community.qlik.com/t5/QlikView/Show-daily-movements-between-dates/m-p/1968958#M1220465 <P>Hi,</P> <P>This feels like something that should be straight forward, but I'm hitting a brick wall!</P> <P>I have a pivot table.&nbsp; I have a dimension which is a date.&nbsp; I have an expression which gives me a count of something (so my result is a count of something across date) - all good.</P> <P>So let's assume my pivot table looks like the below;</P> <P>01/08/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02/08/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03/08/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 04/08/2022</P> <P>&nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 250&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;150</P> <P>I want to show the daily movements on a new row as;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 150&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -100</P> <P>I thought that there would be a simple way to do this in expression?!&nbsp;&nbsp;</P> <P>Any help appreciated!&nbsp;</P> <P>Thanks all <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 16 Aug 2022 06:35:03 GMT https://community.qlik.com/t5/QlikView/Show-daily-movements-between-dates/m-p/1968958#M1220465 DataKnight1 2022-08-16T06:35:03Z https://community.qlik.com/t5/QlikView/Show-daily-movements-between-dates/m-p/1971021#M1220560 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/100304">@DataKnight1</a>&nbsp;Explain the logic behind your output.</P> Sun, 21 Aug 2022 23:27:37 GMT https://community.qlik.com/t5/QlikView/Show-daily-movements-between-dates/m-p/1971021#M1220560 BrunPierre 2022-08-21T23:27:37Z