Stacked Graphic - Percentage 100% with no selection

[martinqlik]

Hello all,

The picture below show the left side with no selections and the right side with the dimension 111, which turn the graphic to all 100% values.

How can I make all the dimensions in that graphic to show 100% without any selections?

Thank you,

[sunny_talwar]

What is your dimension names and what is your expression?

[martinqlik]

dimensions: location and type

= COUNT([%KEY]) / COUNT(TOTAL <[type]> [%KEY])

[martinqlik]

dimensions: location and type = COUNT([%KEY]) / COUNT(TOTAL <[type]> [%KEY])

[johnca]

Take a look at this doc.

It takes your percentage values and loads them. Then the chart shows each id in %. It should give you an idea of how to do it with your data.

HTH,

John

[sunny_talwar]

Expression looks okay... have you checked Relative option for the expression? or Full accumulation?

[martinqlik]

Yeah, I checked all of this.

Sample is attached.

Any other idea?

Thank you,

[rwunderlich · Accepted solution]

Do not check Relative or Accumulation.  Your expression should list the primary dimension in the TOTAL<>

COUNT([CTE LP]) / COUNT(TOTAL<[FILIAL LP]> [CTE LP])

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com