Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
How can I sum the claims based on the customer(country) and not having each amount of claim separately?
Thanks in advance
I see that you are not using the images. Try to add three times the Country(Customer). This should work.
Jordy
Climber
Hi Bhaddour,
Try this:
Sum(TOTAL [Claim])
Jordy
Climber
Thank you !!
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 ?
Which dimensions are you using? Because if only Customer, you only need Sum([Claim]).
Jordy
Climber
I see that you are not using the images. Try to add three times the Country(Customer). This should work.
Jordy
Climber