Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
You could use [First] and [Last] as dimensions and calculate the amount using
=Sum({< [Customer_Info.Country]={'$(vCountry)'} >} [Amount paid])
Wow worked great. Could you explain why?
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.