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

    creating qlik table with special formula

    Tobias Rueger

      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