topic Re: Button ->action excluded selection if variable is set in QlikView

Button ->action excluded selection if variable is set

pernillet — Wed, 10 Feb 2016 14:47:06 GMT

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

Re: Button ->action excluded selection if variable is set

sunny_talwar — Wed, 10 Feb 2016 15:06:45 GMT

May be this:

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

Replace FieldName with the field which contains the observation of 3000

Re: Button ->action excluded selection if variable is set

pernillet — Fri, 12 Feb 2016 08:33:08 GMT

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

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

Re: Button ->action excluded selection if variable is set

sunny_talwar — Fri, 12 Feb 2016 17:31:34 GMT

Awesome, I am glad I was able to direct you