Button ->action excluded selection if variable is set

[pernillet]

Hi.

How to do this with the exclude value.

1) I have made a button which sets a variable to toggle between 1 an 0 (if(NOT3000Selected=0,1,0) )

2) on the same button I have made a "Select in Field" with the search Sting (If(NOT3000Selected=1,3000,NOT(3000)) ->The NOT(3000) removes my selection again.

Now I would like to exclude 3000 instead, but the "Select Excluded" doesn't have a search String.

Hope You can help, and sorry if this question have been posted a million times. Tried to google it, and just returned to dooing Qlikview:)

Best

Pernille

[sunny_talwar]

May be this:

If(NOT3000Selected=1, 3000, '(' & Concat({<FieldName = {3000}>}FieldName, '|') & ')')

Replace FieldName with the field which contains the observation of 3000

[pernillet]

Thank you. It made me go in the rigth direction ...the filal solution was:

If(NOT3000Selected=1, NOT(3000), '('& concat({<FieldName-={3000}>} distinct FieldName, '|')& ')')

[sunny_talwar]

Awesome, I am glad I was able to direct you