Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
mckendry
Contributor
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
Specialist

mckendry
Contributor
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
Contributor
Author

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

Qrishna
Master
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])