Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 

Calculate the Quote conversion Rate

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. 

Labels (1)
0 Replies