Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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
lironbaram
Partner
Partner

Hi 

attach you'll find a qlikview app

with a table with the four expressions you want to display 

View solution in original post

1 Reply
lironbaram
Partner
Partner

Hi 

attach you'll find a qlikview app

with a table with the four expressions you want to display 

View solution in original post