Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
What is your dimension names and what is your expression?
dimensions: location and type
= COUNT([%KEY]) / COUNT(TOTAL <[type]> [%KEY])
dimensions: location and type = COUNT([%KEY]) / COUNT(TOTAL <[type]> [%KEY])
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
Expression looks okay... have you checked Relative option for the expression? or Full accumulation?
Yeah, I checked all of this.
Sample is attached.
Any other idea?
Thank you,
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