Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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%

 

 

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

Contributor III
Contributor III

Hi

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

 

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.