Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Contributor III
Contributor III

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%

 

 

Highlighted

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

Highlighted
Contributor III
Contributor III

Hi

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

 

Highlighted
Contributor III
Contributor III

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.