Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aarnkalle
Contributor III
Contributor III

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

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

13 Replies
aarnkalle
Contributor III
Contributor III
Author

It is showing 0% for all rows !!!

In excel it is easy but not sure what we are missing in Qlik to get row wise %

ActPhysicianActual 2018Actual 2019Expected Result
Ali A355,923.401,074,888.14302%

 

 

sunny_talwar

It might help if you are able to share a qvf document for us to see what you have

aarnkalle
Contributor III
Contributor III
Author

Hi

Unfortunately, i can't share QVF file due to company policy. 

 

aarnkalle
Contributor III
Contributor III
Author

Hi

I just converted data from Pivot Table to "Table" in Qlik app and used below formula -

Sum (CY_Gross) / Sum (PY_Gross)

It works as per business requirements.

Thanks for your help.