Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
Hi,
you can use :
for the current year
=Sum ( {<Year = {"$(=Max(Year))"}>} total YOURINDICATOR)
Previous year
=Sum ( {<Year = {"$(=Max(Year)-1)"}>} total YOURINDICATOR)
cheers,
Please try:
num(Sum (Total Distinct {<ActPhysician, Record1>} (CY_Gross)) / Sum (Total Distinct {<ActPhysician, Record1>} (PY_Gross)),'##.##%')
Thanks for your response. However it is not showing expected results.
sorry but, I can't see the problem.
can you share an extract from your data sets? and the requested outpout !
Please see attached.
what is the formula used for[Actual 2018] and[Actual 2019]?
What is your expression for Actual 2018 and Actual 2019?
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.
Can you try without TOTAL?
Sum(DISTINCT {<ActPhysician, Record1>} CY_Gross)
/
Sum(DISTINCT {<ActPhysician, Record1>} PY_Gross)