1 Reply Latest reply: Mar 4, 2018 8:36 AM by Kwan Siu RSS

    Count different  rate by selection

    Kwan Siu

      Hi Everyone, I am the beginner of QlikView. Now, if I want to count different recipe success rate by selecting the ingredient, Can anyone show me the script in QlikView?Thanks!

       

      To simplifier the case, I make an example as below which only have 2 example:

      Table A: Different Recipe success times:

      Recipe No .of  Sucess TrialsTotal Trial
      A37
      B25
      ..............

      The recipes are made by below ingredient

      Table B: The ingredients of the recipe:

      Recipe Ingredients
      A

      A1

      A2

      B1

      B

      A1

      B1

      B2

      ........

       

      I want to create a selection box in Qlikview, people can select any ingredients in the box, then Qliview will check whether the database exists the corresponding recipe or not, once the database found the result, the success rate will be calculated.

      For example,

      If  I select A1 A2 B2 in ingredients selection box. Since no recipe was made by A1,A2,B2, the success rate is Zero,

      If I select A1 A2 B1 in ingredients selection box. Since recipe A was made by A1 A2 B1, the success rate is 3/7=42.8%

      If I select A1 because A1 can be used for Recipe A and Recipe B, the success rate is (3+2)/(7+5)=41.7%

      Appreciate if anyone can help. Thanks!