Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
panwipa2528
Contributor III
Contributor III
‎2019-06-10 11:33 PM

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 (2)
Labels
pivot_table_MTD_YTD.zip
pivot_table_MTD_YTD.zip
1,841 Views
0 Likes
1 Solution

Accepted Solutions
Vegar
MVP
MVP
‎2019-06-11 12:16 AM

In response to PrashantSangle
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...
Vegar
Qlik Community MVP

View solution in original post

1,824 Views
0 Likes
3 Replies
PrashantSangle
MVP
MVP
‎2019-06-10 11:44 PM

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 🙂
1,836 Views
0 Likes
Vegar
MVP
MVP
‎2019-06-11 12:16 AM

In response to PrashantSangle
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...
Vegar
Qlik Community MVP
1,825 Views
0 Likes
panwipa2528
Contributor III
Contributor III
‎2019-06-11 03:07 AM
Author

In response to Vegar

Thank you for your help.

1,808 Views