Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
MVP
MVP

Re: Percentage Rollup

Try this:

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

Assuming CategoryDesc is your highest dimension here

4 Replies
MVP
MVP

Re: Percentage Rollup

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

rittermd
Honored Contributor

Re: Percentage Rollup

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

MVP
MVP

Re: Percentage Rollup

Try this:

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

Assuming CategoryDesc is your highest dimension here

rittermd
Honored Contributor

Re: Percentage Rollup

Perfect.  Thank you.