Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
bhaddour
Contributor II
Contributor II

Climber Cards

Hi everyone, 

I'm a beginner with QlikSense (used it for the first time a couple of days ago). 

I'm trying to build a climber card ,but something is wrong. 

I want to have the top 3 of my customers(country) based on their TOTAL amount of the claim. 

 

claims.PNG

How can I sum the claims based on the customer(country) and not having each amount of claim separately?

Thanks in advance

1 Solution

Accepted Solutions
JordyWegman
Partner - Master
Partner - Master

I see that you are not using the images. Try to add three times the Country(Customer). This should work.

Jordy

Climber

Work smarter, not harder

View solution in original post

6 Replies
JordyWegman
Partner - Master
Partner - Master

Hi Bhaddour,

Try this:

Sum(TOTAL [Claim])

Jordy

Climber

Work smarter, not harder
bhaddour
Contributor II
Contributor II
Author

Thank you !!

bhaddour
Contributor II
Contributor II
Author

Now It's showing the TOTAL of all claims and not per customer . 

I heard about linking a dimension , can it be the solution if yes how do I proceed ?

JordyWegman
Partner - Master
Partner - Master

Which dimensions are you using? Because if only Customer, you only need Sum([Claim]).

Jordy

Climber

Work smarter, not harder
bhaddour
Contributor II
Contributor II
Author

Capture.PNG

JordyWegman
Partner - Master
Partner - Master

I see that you are not using the images. Try to add three times the Country(Customer). This should work.

Jordy

Climber

Work smarter, not harder