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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! 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.