Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Calculate percentage of grand total

I have a data modal like the printscreen below:

2016-02-22 14_01_38-Map1 - Excel.png

Now I want to show the absence percentage per Year-period / Type

The total absence for period 2016-02 is 50% and per type is 25%.

In my barchart I have 2 dimensions:  Year-Period and Type and 1 measure something like Sum(Absence hour) / Sum(Hour).

The problem is the bar chart always show 100% because it devides 16 by 16 or 8 by 8.

How can I make my bar chart it shows 50% in 2 dimensions (Type) of each 25%? I would like to devide Type (=8) by total hours (=32). I can not make this work. Can someone point me in a good direction?

1 Solution

Accepted Solutions
MVP
MVP

Re: Calculate percentage of grand total

May be this:

Sum(Absence hour) / Sum(TOTAL <Year-Period> Hour)

2 Replies
MVP
MVP

Re: Calculate percentage of grand total

May be this:

Sum(Absence hour) / Sum(TOTAL <Year-Period> Hour)

Not applicable

Re: Calculate percentage of grand total

That's it! How simple.

Many thanx!

Community Browser