Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help in a complex expression(Converting Excel formulae to expressions)

Hi ,

I have a excel sheet which contains data of which one coloum is calculated based on the previous coloumn value with a formule

=1+SUM(B5:B$12)/SUM(B$2:B3)   where  B represents  the previous coloumn  . I trying to replicate the same sheet in qlikview pivot object .

I am not been able to found the solution to this formulae in expression . I am attaching the sample application as well as the Excel sheet which contains the report which i want to replicate in qlikview .

Can any one help me or is this even possible in qlikview application ?

Regards

Tushar

0 Replies