Need your help to get a percentage (Current Year Total / Previous Year Total)

[aarnkalle]

Hi

I need your help to get a percentage (Current Year Total / Previous Year Total) on a row in Qliksense Pivot.

Sum (Total Distinct {<ActPhysician, Record1>} (CY_Gross)) / Sum (Total Distinct {<ActPhysician, Record1>} (PY_Gross))

[Taoufiq_Zarra]

Hi,

you can use :

for the current year

=Sum ( {<Year = {"$(=Max(Year))"}>} total   YOURINDICATOR)

Previous year

=Sum ( {<Year = {"$(=Max(Year)-1)"}>} total   YOURINDICATOR)

cheers,

[anushree1]

Please try:

num(Sum (Total Distinct {<ActPhysician, Record1>} (CY_Gross)) / Sum (Total Distinct {<ActPhysician, Record1>} (PY_Gross)),'##.##%')

[aarnkalle]

Thanks for your response. However it is not showing expected results.

[Taoufiq_Zarra]

sorry but, I can't see the problem.

can you share an extract from your data sets? and the requested outpout !

[aarnkalle]

Please see attached.

[Taoufiq_Zarra]

what is the formula used for[Actual 2018] and[Actual 2019]?

[sunny_talwar]

What is your expression for Actual 2018 and Actual 2019?

[aarnkalle]

Sum (Total Distinct {<ActPhysician, Record1>} (CY_Gross)) / Sum (Total Distinct {<ActPhysician, Record1>} (PY_Gross))

"Record1" having filter for Actual 2018 and Actual 2019 data.

"CY_Gross" is the value for Actual 2019 and "PY_Gross" is the value for Actual 2018.

[sunny_talwar]

Can you try without TOTAL?

Sum(DISTINCT {<ActPhysician, Record1>} CY_Gross)
/
Sum(DISTINCT {<ActPhysician, Record1>} PY_Gross)