Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

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

View solution in original post

7 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

It would be helpful if you share sample QVW file.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

i updatd solution

luciancotea
Specialist
Specialist

The formula for the Percentage is:

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

Anonymous
Not applicable
Author

like this?

Not applicable
Author

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

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

Genius