Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
martinqlik
Contributor III
Contributor III

Stacked Graphic - Percentage 100% with no selection

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,

 

 

Labels (3)
1 Solution

Accepted Solutions
rwunderlich

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

 

View solution in original post

7 Replies
sunny_talwar

What is your dimension names and what is your expression?

martinqlik
Contributor III
Contributor III
Author

dimensions: location and type

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

martinqlik
Contributor III
Contributor III
Author

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

johnca
Specialist
Specialist

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.

image.png

HTH,

John

sunny_talwar

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

martinqlik
Contributor III
Contributor III
Author

Yeah, I checked all of this.

Sample is attached.

Any other idea?

 

Thank you,

rwunderlich

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