Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
11deanm
Contributor
Contributor

Using variables to find names

I have a list of First Names and Last Names and Countries. I want to find out based on a variable(country) the first, last and the amount the person paid. How would I do something like this:
=({<[Customer_Info.Country]={'$(vCountry)'}>}[First Name])

3 Replies
Vegar
MVP
MVP

You could use [First] and [Last] as dimensions and calculate the amount using 

=Sum({< [Customer_Info.Country]={'$(vCountry)'} >} [Amount paid])

11deanm
Contributor
Contributor
Author

Wow worked great. Could you explain why?

Vegar
MVP
MVP

Qlik Sense will normally only display dimensions with expression values. By creating an expression (using SET analysis) that is only calculating a certain country will exclude all names not associated with that country.