Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
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.
Vegar
MVP
MVP

Good morning.
Take a look at this post by @rahulpawarb , I believe it covers what you want to do.
https://community.qlik.com/t5/QlikView-Documents/Date-Level-Analysis-WTD-MTD-QTD-YTD-Current-Year-Pr...
panwipa2528
Contributor III
Contributor III
Author

Thank you for your help.