topic Re: button to toggle in QlikView

button to toggle

surajap123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have below dataset. I want to filter data on Status field using a button.

Data:
LOAD * INLINE [
    No, Status, Dim, Amount
    1, Open, dim1, 456
    2, Completed, dim2, 43
    3, Open, dim3, 23
    4, Assigned, dim4, 762
];

I wanted to cleate a single button that act as toggle.
One first click it should show all values in status field(logically clearing selections on status field) and on next click on the same button it should EXCLUDE 'completed' status.

Please help!

Re: button to toggle

tresB — Wed, 17 May 2017 10:47:30 GMT

PFA

Re: button to toggle

prma7799 — Wed, 17 May 2017 10:57:43 GMT

Please check ....

Re: button to toggle

Sergey_Shuklin — Wed, 17 May 2017 11:02:59 GMT

Hi, Suraj!

Create a button and the variable, name variable for instance vButtonClick. In Action Tab of Button properties choose an action "set variable" in External block and make this condition for variable vButtonClick: =if(vButtonClick=1,0,1). Then make a second action which will do a selection in field (Selection - Select in Field):

=if(vButtonClick=1,'=wildmatch(Status,'&chr(39)&'*Completed*'&chr(39)&')=0',)

First click should clear all, and the second should select all except values with 'Completed' string.

Hope it helps!

Re: button to toggle

surajap123 — Wed, 17 May 2017 11:17:38 GMT

Thanks everyone for the help. Sergey's expression helped me to pass multiple values.

thanks again.