
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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])}


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
what is it supposed to calculate?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I would like the .55247.... to show up on every column instead of the unique values


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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])
