Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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 ?



Community Browser