Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vpanchuda
Contributor III
Contributor III

Calculations with set analysis in Pivot table

HI I would like to build output in a Pivot Table for the below data, tried a lot and messed up it would be a great help if someone helps me out to calculate and get the below output with set expressions.'

 

INPUT TABLE 

 

IDReferenceStatusDuedate
1A1YES 
2B1NO11-07-2019
3C1NO12-07-2019
4A1NO13-07-2019
5B1NO17-08-2019
6C1YES 
7C1NO16-08-2019
8B1YES 
9A1NO18-09-2019
10A1NO18-10-2019

 

Desired OUT PUT table should look like below.

1- the count as per today.

2- TOTAL YES for all Reference(A1,B1,C1) --This adds up the count of  NO to YES on the months where its converted on the respective month/date.

 

 

Count of Status wrt WeightToday(Count as per today)30-07-2019(end of next month)30-08-2019(+30 days from Previous month)30-09-2019(+30 days from Previous month)30-10-2019(+30 days from Previous month)30-07-2019(+30 days from Previous month)
 TOTAL YES for all Reference(A1,B1,C1)368910 
Missing Due Date222222
A1-NO32210 
B1-NO21000 
C1-NO21000 
TOTAL number of No conversions reduced every month74210

 

0 Replies