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: 
upaliwije
Creator II
Creator II

Pivot Table

PRODUCTRETURNS_MAYAbove 25th DayRETURNS PURCHASED MONTH  JANRETURNS PURCHASED MONTH  FEBRETURNS PURCHASED MONTH  MARRETURNS PURCHASED MONTH  APR
A64,084,66145,747,4120
B60,651,99547,143,9330
C41,744,18920,974,1500
D35,762,22324,707,7340
E24,843,22316,197,8370
Total359,662,112224,263,9110

I have above pivot table where 1 st column indicate the product

2 column shows total returns for the month of may

3 column goods returned after 25th of any month

4 ,5,6,7 columns should show the  returns value  in relation to purchased months of goods returned (after 25th day)

My expression  for 2 and 3 columns are as follows

2  column     SUM(RETURNS)

3 COLUMN  =SUM({<R_DAY = {">25"}>} [RETURNS])

R_DAY=Returned day

R_MONTH = Returned Month

P_Month= Purchased Month

above are dates in master calender.

Pls help me to write the expression for the above 4 columns (4,5,6,7)

0 Replies