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: 
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
982 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 🙂
977 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
966 Views
0 Likes
panwipa2528
Contributor III
Contributor III
‎2019-06-11 03:07 AM
Author

In response to Vegar

Thank you for your help.

949 Views