Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
pernillet
New Contributor

Button ->action excluded selection if variable is set

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

3 Replies

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

May be this:

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

Replace FieldName with the field which contains the observation of 3000

pernillet
New Contributor

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

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

Awesome, I am glad I was able to direct you