Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

creating qlik table with special formula

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

1 Solution

Accepted Solutions
luciancotea
Valued Contributor

Re: creating qlik table with special formula

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

7 Replies

Re: creating qlik table with special formula

Hi,

It would be helpful if you share sample QVW file.

Regards,

Kaushik Solanki

Not applicable

Re: creating qlik table with special formula

i updatd solution

luciancotea
Valued Contributor

Re: creating qlik table with special formula

The formula for the Percentage is:

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

balrajahlawat
Esteemed Contributor

Re: creating qlik table with special formula

like this?

Not applicable

Re: creating qlik table with special formula

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
Valued Contributor

Re: creating qlik table with special formula

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

Re: creating qlik table with special formula

Genius

Community Browser