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: 
Anonymous
Not applicable

Need help in Pivot table

Hi Expert

I have pivot table as below and need formula to get values for exp5

Exp1,Exp2,Exp3 are calcualted expression with more formula ex:sum({<Type={'Revenue'},MthOrder={">=$(=vMaxMth-2)<=$(=vMaxMth)"},Mth=,FiscalYear=>}ValueCol1)

Dim1Dim2Exp1Exp2Exp3Exp4Exp5
(Exp1+Exp2)-Exp3 (Total DIM1 Values)
1U00Ctry1302515       4050(40+10)
Ctry23575100       1050(40+10)
1P00Ctry1352738      2469(24+45)
Ctry2234422      4569(24+45)
7 Replies
Not applicable
Author

explain the exp5= ?

avinashelite

What is the logic to calculate exp5??

mohamed_ahid
Partner - Specialist
Partner - Specialist

HI,

aggr(sum(exp4) , Dim1)

or

Sum(<Dim1>aggr(sum(exp4) , Dim1))

antoniotiman
Master III
Master III

Try

RangeSum(Top(Column(4),1,NoOfRows()))

Anonymous
Not applicable
Author

thanks Mohamed i got the answer by your formula.

Anonymous
Not applicable
Author

Thanks Antonio i got answer by your formula , can you please explain formula. I could not understand

antoniotiman
Master III
Master III

Sum values of Column 4 from First Row to Last row of Dimension 1

You can change Column(4) to Label Name of Column or repeat same Expression

See RangeSum() function and Top() function in QV help

Regards,

Antonio