Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jleberre
Contributor II
Contributor II

Remove selections in a set analysis using a variable

Hello

I would like to remove some selections in a set analysis, using a variable.

I tried this:

- the variable: vSelection = 'customer=,offer=,country=,city=' for example

- the set analysis: {<$(vSelection)>}

But it doesn't work (no selection removed).

It works when there is only one field in the variable :

- vSelection='customer'

- set analysis = {<$(vSelection)=>}

(the selection in customer is removed)

I have lots of selections to remove for some measure, and I would like to use a variable, in order to more rapidly and easily adjust the list of selections to remove.

How can I do this please?

Thanks!

1 Solution

Accepted Solutions
yddona_lyn
Contributor III
Contributor III

Have you tried removing the ' '.

variable:

vSelection = customer=,offer=,country=,city=

set analysis

{<$(vSelection)>}

View solution in original post

4 Replies
swuehl
MVP
MVP

seems to work for me.

Could you post a small sample QVW that demonstrates your issue?

yddona_lyn
Contributor III
Contributor III

Have you tried removing the ' '.

variable:

vSelection = customer=,offer=,country=,city=

set analysis

{<$(vSelection)>}

Anil_Babu_Samineni

How are you defining the variable

Seems working for me, Here you are ignoring the Customer

Capture.PNG

Variable define

Capture.PNG

Output seems this?

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
jleberre
Contributor II
Contributor II
Author

It works without the ' ' in the variable

thanks!