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
lironbaram
Partner - Master III
Partner - Master III

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 - Master III
Partner - Master III

Hi 

attach you'll find a qlikview app

with a table with the four expressions you want to display