Announcements
Sept. 27, 10AM ET Do more with Qlik, Insight Advisor – our intelligent AI-assistant in Qlik Sense: Register
cancel
Showing results 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)

 Dim1 Dim2 Exp1 Exp2 Exp3 Exp4 Exp5 (Exp1+Exp2)-Exp3 (Total DIM1 Values) 1U00 Ctry1 30 25 15 40 50(40+10) Ctry2 35 75 100 10 50(40+10) 1P00 Ctry1 35 27 38 24 69(24+45) Ctry2 23 44 22 45 69(24+45)
7 Replies
Not applicable
Author

explain the exp5= ?

MVP

What is the logic to calculate exp5??

Partner - Specialist

HI,

aggr(sum(exp4) , Dim1)

or

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

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

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

Community Browser