Skip to main content

App Development

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

Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
Showing results for 
Search instead for 
Did you mean: 
Partner - Specialist
Partner - Specialist

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. 

0 Replies