Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Highlighted
nehapathak
New Contributor II

how to use variables in measures in qliksense

I want to create a variable that stores a set of countries

let countries=['IDN','PHL','MYS','NGA','KEN','ZMB','RWA'];    //variable creation

and want to use the variable "countries" inside a measure.

1 Reply
MVP
MVP

Re: how to use variables in measures in qliksense

Use it within set analysis? May be try this

SET vCountries = {'IDN','PHL','MYS','NGA','KEN','ZMB','RWA'};

and then this

Sum({<Country = $(vCountries)>}Measure)

Community Browser