Skip to main content

Qlik

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
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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 (1)
Labels
pivot_table_MTD_YTD.zip
pivot_table_MTD_YTD.zip
1,255 Views
0 Likes
1 Solution

Accepted Solutions
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,250 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,239 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,222 Views