Discussion board where members can learn more about Qlik Sense App Development and Usage.
Good morning.
I would like to calculate the % is accepted Quote items against the items in a Quote. This will be against a Customer and / or Product code. Looking at the snippet, the top Table uses the Cyclic dimension, the middle Table is by Product and the bottom Table is by Customer.
In the top Table (Cyclic Table), I am using Avg instead of Auto. The last column is set to Auto. The question is that I am expecting the total in the "Quoted / Picked hit Rate" to also be at 80% instead of 83.33%.
I also attach the App so you can see the expression.
Thank you in advance.
