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: 
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