Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Please visit COVID-19 group to keep up the discussion. GO TO GROUP
Highlighted
Honored Contributor

Percentage Rollup

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?

1 Solution

Accepted Solutions
Highlighted

Re: Percentage Rollup

Try this:

If(Dimensionality() = 1 or Dimensionality() = 4, Sum(RugDays)/Sum(Total <CategoryDesc> RugDays),' ')

Assuming CategoryDesc is your highest dimension here

View solution in original post

4 Replies
Highlighted

Re: Percentage Rollup

Can you share your current expression and the name of your dimensions?

Honored Contributor

Re: Percentage Rollup

If (dimensionality() = '1' OR dimensionality() = '4',Sum(RugDays)/Sum(Total RugDays),' ')

Highlighted

Re: Percentage Rollup

Try this:

If(Dimensionality() = 1 or Dimensionality() = 4, Sum(RugDays)/Sum(Total <CategoryDesc> RugDays),' ')

Assuming CategoryDesc is your highest dimension here

View solution in original post

Highlighted
Honored Contributor

Re: Percentage Rollup

Perfect.  Thank you.