Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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