Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.