Discussion Board for collaboration on QlikView Scripting.
I want expression to be written in Guage for calculating Profitability with given parameters -
Profit is - P1,P2,P3....Pn
Value is - V1,V2,V3....Vn
Guage should calculate - Profitability -
(P1+P2+P3+....+Pn) / (V1+V2+V3+...+Vn)
div(Sum(Profit),Sum(value)) is not working in expression
Go to Solution.
I got it
Sum(Profit)/Sum(Value) gave me the desired answer.
Thanks for the help.
You said P1, P2, P3 ... Pn. But all are string or numbers
Its a table where P1, P2 P3 are Profit numbers for Item1, Item2, Item3... Itemn corresponding to Final Value of V1, V2 V3
Can you show data please how profit and and value looks?
Hi are you expecting like this in Guage chart
Yes I am expecting this calculation
But when i put the below expression in Qlik sense,
the calculated field shows "0"
Seems, Qliksense also working