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 Trials | Total Trial |
|---|
| A | 3 | 7 |
| B | 2 | 5 |
| .... | ..... | ..... |
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!
