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))
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 %
ActPhysician | Actual 2018 | Actual 2019 | Expected Result |
Ali A | 355,923.40 | 1,074,888.14 | 302% |
It might help if you are able to share a qvf document for us to see what you have
Hi
Unfortunately, i can't share QVF file due to company policy.
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.