# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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

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