Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want expression to be written in Guage for calculating Profitability with given parameters -
Where
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
Please guide
Thanks,
Vikas
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
@Anil,
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?
Item | Type | value | Profit |
Low Makeable | C | 1,302.40 | 78.10 |
Cubes | M | 1,178.10 | 94.20 |
Cubes | M | 2,077.50 | 145.40 |
Cubes | M | 3,945.92 | 315.70 |
Cubes | M | 1,952.50 | 156.20 |
High Makeable | M | 509.86 | 56.10 |
High Makeable | M | 3,063.95 | 76.60 |
High Makeable | M | 1,105.56 | 71.90 |
Blacks | M | 1,385.00 | 13.90 |
Blacks | M | 2,552.00 | 25.50 |
Blacks | M | 1,488.36 | 14.90 |
Seems working
Or
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,
Div(Sum(Profit),Sum(value))
the calculated field shows "0"
NO
Seems, Qliksense also working