7 Replies Latest reply: Mar 15, 2016 7:03 AM by Sunny Talwar

# 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 ???

Message was edited by: Tobias Rueger

Message was edited by: Tobias Rueger

• ###### Re: creating qlik table with special formula

Hi,

It would be helpful if you share sample QVW file.

Regards,

Kaushik Solanki

• ###### Re: creating qlik table with special formula

i updatd solution

• ###### Re: creating qlik table with special formula

The formula for the Percentage is:

• ###### Re: creating qlik table with special formula

Genius

• ###### Re: creating qlik table with special formula

like this?

• ###### Re: creating qlik table with special formula

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