Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
rittermd
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?

Highlighted
rittermd
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
rittermd
Honored Contributor

Re: Percentage Rollup

Perfect.  Thank you.