topic Re: creating qlik table with special formula in QlikView

creating qlik table with special formula

Tue, 15 Mar 2016 09:08:11 GMT

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

kaushiknsolanki — Tue, 15 Mar 2016 09:51:46 GMT

Hi,

It would be helpful if you share sample QVW file.

Regards,

Kaushik Solanki

Tue, 15 Mar 2016 10:29:07 GMT

i updatd solution

luciancotea — Tue, 15 Mar 2016 10:40:07 GMT

The formula for the Percentage is:

=Exp(Sum(Log(aggr(Sum(Good)/Sum(Good + Bad), Step))))

Anonymous — Tue, 15 Mar 2016 10:43:25 GMT

like this?

Tue, 15 Mar 2016 10:53:39 GMT

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

luciancotea — Tue, 15 Mar 2016 11:01:45 GMT

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

sunny_talwar — Tue, 15 Mar 2016 11:03:45 GMT

Genius