topic Re: How to exclude/remove multiple values at a time from list box in QlikView

How to exclude/remove multiple values at a time from list box

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

HI All, How to exclude/remove multiple values at a time from list box Example: I have 10 values I a list box amount 123456 12/23 ver. 11/23 s1 5/25 s2 6/26 ver like that I want only 12/23ver value and 6/26 value remaining values not needed to me amount --> is a text value in the list box 6/26 --> also a text value. reaming are numbers. Could you please suggest me how to process that one Thanks In Advance

Re: How to exclude/remove multiple values at a time from list box

YoussefBelloum — Fri, 13 Jul 2018 12:18:33 GMT

Hi,

the values you want to keep and those you want to excluse are not clear.

would you be able to share a screen shot of that listbox ?

you can use if(not match....

Re: How to exclude/remove multiple values at a time from list box

dapostolopoylos — Fri, 13 Jul 2018 12:19:57 GMT

You can modify the listbox to be populated not directly from the Field but by an expression like this one:

=Match(Field,'Value1','Value2','Value3')

Re: How to exclude/remove multiple values at a time from list box

YoussefBelloum — Fri, 13 Jul 2018 12:25:24 GMT

Hi,

it is not a conditional display expression section, so you need to use IF statement and specify the output field, like this:

=if(Match(Field,'Value1','Value2','Value3'),Field)

Re: How to exclude/remove multiple values at a time from list box

SNR1 — Fri, 13 Jul 2018 12:38:56 GMT

HI Yousuf , Thanks for the info i want to display only few values in the list as of now once qvw reloaded after a week new field is also added to the list box only few values ( 11/23 s1 5/25, amount ) need to hide permanently. if you have any questions please tell me I need to solve this issue asasp. Ex: amount; 123456; 12/23 ver. ; 11/23 s1; 5/25 s2; 6/26 ver ; I want to excludebelow values amount; 12/23 ver. ; 11/23 s1; 5/25 s2; SO my list like below 123456; 6/26 ver ; once qvw app reloaded with new data list box like below 123456; 6/26 ver ; new filed1 newfiled2 Thanks In Advance

Re: How to exclude/remove multiple values at a time from list box

YoussefBelloum — Fri, 13 Jul 2018 12:42:29 GMT

as shown by dimitrios, use an expression on your listbox and try this:

=if(not match(YOUR_FIELD,'THE VALUE YOU WANT TO EXCLUSE','ANOTHER VALUE YOU WANT TO EXCLUSE','ONE MORE VALUE YOU WANT TO EXCLUSE'), YOUR_FIELD)

like this you will have all your values except the list you wrote on the expression.

Re: How to exclude/remove multiple values at a time from list box

dapostolopoylos — Fri, 13 Jul 2018 12:49:34 GMT

Yes, you are right, my mistake.

Re: How to exclude/remove multiple values at a time from list box

SNR1 — Fri, 13 Jul 2018 12:56:45 GMT

Thanks Yousuf For the info I need one more question Regarding to list box default selection if you don't mine please help I have a list box default selection for a value when ever I open the document that value selected in list box and highlighted with green color (02/22 ver.) (03/22 ver.) (04/23 ver.) (05/23 ver.) (06/23 ver.) (10/23 ver.)(prev year) I want latest version as a default and highlighted with green color in list box . if the app reloaded with new data then new version(07/26) is added to list box and new version (07/26) is the default I used trigger onopen but its not working properly. is there any other way to default selection of listboxes Please suggest me Thanks In Advance.

Re: How to exclude/remove multiple values at a time from list box

YoussefBelloum — Fri, 13 Jul 2018 13:08:37 GMT

I don't think OnOpen Trigger will work on the accesspoint.

take a look at this: Issue with trigger on opening document

Re: How to exclude/remove multiple values at a time from list box

SNR1 — Fri, 13 Jul 2018 14:12:52 GMT

HI Youssef, I tried that method also but I'm getting same result could you please suggest me other way to highlight the default selection in list box with green color. Thanks In Advance

Re: How to exclude/remove multiple values at a time from list box

YoussefBelloum — Fri, 13 Jul 2018 14:15:28 GMT

would you be able to share sample app ?

Re: How to exclude/remove multiple values at a time from list box

SNR1 — Fri, 13 Jul 2018 14:19:01 GMT

HI Youssef, Could you please suggest how make default selection in list box with color as well. I have two list boxes with like below Source 1: (02/22 ver.) (03/22 ver.) (04/23 ver.) (05/23 ver.) (10/23 ver.)-->(prev year) Source2 : (02/22 ver.) (03/22 ver.) (04/23 ver.) (05/23 ver.) (06/23 ver.) (10/23 ver.)-->(prev year) I need default selection of source1 is (05/23 ver,) and source2 is (06/23) when ever I opened the qvw app above values needs to be selected by default. and once data updated new data versions are added to list box for list box1(source1) like (06/23) and listbx2(source2) is with (07/20) after updating the app I need above mentioned values as default. could you please suggest me Thanks In Advance

Re: How to exclude/remove multiple values at a time from list box

SNR1 — Fri, 13 Jul 2018 15:23:48 GMT

HI Yousserf ,

please find the sample attachment.

Thanks

in Adavance