Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mckendry
Contributor

Moving from Tableau to Qlik

I am recreating a dashboard I built in Tableau to Qlik and am having trouble recreating the following formula in Qlik 

{FIXED:([CY Classified Contacts]/[CY Offered Contacts])}  

Labels (2)
4 Replies
mikaelsc
Specialist

mckendry
Contributor
Author

I am looking at % of contacts that were classified. I am trying to get a fixed number for a chart and am currently getting unique values 

mckendry
Contributor
Author

I would like the .55247.... to show up on every column instead of the unique values 

Qrishna
Master

what is CY weight? is it summation of Weight for Current Year?

if you want to calculate the avg: Sum(total [CY Weight])/count(total [ Contacts]) - this populates a unique number across all rows in the column.

{FIXED:([CY Classified Contacts]/[CY Offered Contacts])}  : count(total [CY Classified Contacts])/count(total [CY Offered Contacts])