Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
johngouws
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. 

Capture.PNG

Thank you in advance. 

0 Replies