Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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
Anonymous
Not applicable

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?

Anonymous
Not applicable

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
jleberre
Contributor II
Contributor II
Author

It works without the ' ' in the variable

thanks!