Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Pivot table as shown below.
Right now the Days% is calculating for each section as a part of the whole total. What I want is for each section to total up to 100% ignoring the other sections.
For example in Medicare A RUG Mix for Ultra High RUB I want that to display 85.86% (346/403) instead of 61.24% (346/565)
Is this possible to do in Qlik Sense?
Try this:
If(Dimensionality() = 1 or Dimensionality() = 4, Sum(RugDays)/Sum(Total <CategoryDesc> RugDays),' ')
Assuming CategoryDesc is your highest dimension here
Can you share your current expression and the name of your dimensions?
If (dimensionality() = '1' OR dimensionality() = '4',Sum(RugDays)/Sum(Total RugDays),' ')
Try this:
If(Dimensionality() = 1 or Dimensionality() = 4, Sum(RugDays)/Sum(Total <CategoryDesc> RugDays),' ')
Assuming CategoryDesc is your highest dimension here
Perfect. Thank you.