Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

aniketsr
New Contributor III

How to get a value in the list which will select all values in the list

Hi ,

I have a requirement which states as follows:


I have a List box for region and the values in the list box are (NAM,EMEA,APAC,LATAM)

now my requirement is that i want one more value in the list which will select all the region in the list box and the name of the value shall be ALL.

Any help with this regards will be appreciated

Thank you in advance.

1 Solution

Accepted Solutions

Re: How to get a value in the list which will select all values in the list

Region:

Load distinct Region, Region as REGION

Resident DATA;

Concatenate (Region)

load Region, 'ALL' as REGION

resident Region ;

Now use REGION as your selection

3 Replies
sureshqv
Esteemed Contributor III

Re: How to get a value in the list which will select all values in the list

am not sure

create a inline table with the region vlaues with all

load *Inline [

region,All

];

Re: How to get a value in the list which will select all values in the list

Region:

Load distinct Region, Region as REGION

Resident DATA;

Concatenate (Region)

load Region, 'ALL' as REGION

resident Region ;

Now use REGION as your selection

techvarun
Valued Contributor II

Re: How to get a value in the list which will select all values in the list

Community Browser