Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
jblomqvist
Specialist
Specialist

How to show percentage for each Dimension value in Text Pop-up excluding Dimension Limits setting?

Hi all,

I have a bar chart where my Dimension is ClaimType.

The dimension values could be Internal, External, CompanyMeetings, Marketing, etc.

My Expression is Sum(Value).

My Dimension Limit is Largest 5.

How can I get my bar chart to show the percentage of value based on all claim types beyond the dimension limits?

I want to show this in Text as Pop up in the bars.

I've attached an example app to help illustrate.

In there the top 5 chart uses dimension limits, the straight table shows all values. In the Bar Chart I want to see percentage of expenses that was for Training, Marketing etc and not just be limited to dimension limits.

Anyone know how this is possible?

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try expression: =sum(Value)/sum(Total Value)

View solution in original post

4 Replies
tresesco
MVP
MVP

Try expression: =sum(Value)/sum(Total Value)

Clever_Anjos
Employee
Employee

Sum(Value)/Sum(Total <ClaimType> Value) should return what you need

jblomqvist
Specialist
Specialist
Author

Hi Tresesco and Clever,

Thanks I think =sum(Value)/sum(Total Value) works.

What is the difference between TOTAL function and doing Sum({1} Value)?

tresesco
MVP
MVP

{1} - is set analysis modifier; ignores all selections in same state.

Total - ignores the dimension but selections