https://community.qlik.com/t5/QlikView/How-to-prepare-pivot-table-have-data-MTD-and-YTD/m-p/1590236#M443502 <P>1. I have daily raw data from 2 persons. (Data since 1/1/2018-28/5/2019)<BR />2. I want to know sum(Sale) from 1-28 May 2018 &amp; 1-28 May 2019<BR />3. I want to know sum(Sale) from 1-Jan - 28 May 2018 &amp; 1-Jan - 28 May 2019<BR />4. Need to see 2 &amp; 3 same table</P> Sat, 16 Nov 2024 03:20:47 GMT panwipa2528 2024-11-16T03:20:47Z https://community.qlik.com/t5/QlikView/How-to-prepare-pivot-table-have-data-MTD-and-YTD/m-p/1590236#M443502 <P>1. I have daily raw data from 2 persons. (Data since 1/1/2018-28/5/2019)<BR />2. I want to know sum(Sale) from 1-28 May 2018 &amp; 1-28 May 2019<BR />3. I want to know sum(Sale) from 1-Jan - 28 May 2018 &amp; 1-Jan - 28 May 2019<BR />4. Need to see 2 &amp; 3 same table</P> Sat, 16 Nov 2024 03:20:47 GMT https://community.qlik.com/t5/QlikView/How-to-prepare-pivot-table-have-data-MTD-and-YTD/m-p/1590236#M443502 panwipa2528 2024-11-16T03:20:47Z https://community.qlik.com/t5/QlikView/How-to-prepare-pivot-table-have-data-MTD-and-YTD/m-p/1590253#M443508 <P>Hi&nbsp;</P><P>attach you'll find a qlikview app</P><P>with a table with the four expressions you want to display&nbsp;</P> Tue, 11 Jun 2019 05:24:40 GMT https://community.qlik.com/t5/QlikView/How-to-prepare-pivot-table-have-data-MTD-and-YTD/m-p/1590253#M443508 lironbaram 2019-06-11T05:24:40Z