Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
panwipa2528
Contributor III
Contributor III

How to prepare pivot table have data MTD and YTD?

1. I have daily raw data from 2 persons. (Data since 1/1/2018-28/5/2019)
2. I want to know sum(Sale) from 1-28 May 2018 & 1-28 May 2019
3. I want to know sum(Sale) from 1-Jan - 28 May 2018 & 1-Jan - 28 May 2019
4. Need to see 2 & 3 same table

Labels (1)
1 Solution

Accepted Solutions
3 Replies
PrashantSangle

Hi,

Avoid duplicate thread .
https://community.qlik.com/t5/QlikView-App-Development/How-to-prepare-pivot-table-have-data-MTD-and-...

https://community.qlik.com/t5/QlikView-App-Development/How-to-prepare-pivot-table-have-data-MTD-and-...

Delete any one of it.

Regards,
Prashant Sangle
Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
panwipa2528
Contributor III
Contributor III
Author

Thank you for your help.