Re: Moving from Tableau to Qlik - Qlik Community

mckendry

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])}

mikaelsc

what is it supposed to calculate?

mckendry

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

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

Qrishna

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

Moving from Tableau to Qlik