Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
If(NOT3000Selected=1, 3000, '(' & Concat({<FieldName = {3000}>}FieldName, '|') & ')')
Replace FieldName with the field which contains the observation of 3000
Thank you. It made me go in the rigth direction ...the filal solution was:
If(NOT3000Selected=1, NOT(3000), '('& concat({<FieldName-={3000}>} distinct FieldName, '|')& ')')
Awesome, I am glad I was able to direct you