Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following data structure as a qlik table:
All Good Not-OK Percentage
Step A 10 8 2 80,0 (Good/All = 8/10)
Step B 9 6 3 66,7 (Good/All = 6/9)
Step C 12 8 4 66,7 (Good/All = 8/12)
overall Percentage: 80 % * 66,7 % * 66,7 % = 35,9 % (multiply each single value)
The table can be illustrated very easily except the last calculated value 35,9 %:
In Excel it would be the function PRODUCT(d2:d5) over the table.
How can I transfer this logic from Excel to Qlik ???
Is there any way to do this ? I only know sum values, but what about such calculated / formula values ???
Thnaks for your input
Message was edited by: Tobias Rueger
Message was edited by: Tobias Rueger
In your example:
- Go to Chart Properties -> Presentation -> Show Partial Sums (for step dimension)
- Go to Expressions and replace the "ok percentage" formula with this:
=Exp(Sum(Log(aggr(Sum(ok)/Sum(whole), step))))
Hi,
It would be helpful if you share sample QVW file.
Regards,
Kaushik Solanki
i updatd solution
The formula for the Percentage is:
=Exp(Sum(Log(aggr(Sum(Good)/Sum(Good + Bad), Step))))
like this?
thanks for your answer
I added excel file to explain better what I need:
I do not understand which steps to do, because I think i need to add an additonal cell or additional text field ?
please detailed info if possible that i can update this test solution
thanks in advance
In your example:
- Go to Chart Properties -> Presentation -> Show Partial Sums (for step dimension)
- Go to Expressions and replace the "ok percentage" formula with this:
=Exp(Sum(Log(aggr(Sum(ok)/Sum(whole), step))))
Genius