topic Re: GetFieldSelections with AND condition not working in QlikView

GetFieldSelections with AND condition not working

ashis — Sat, 16 Nov 2024 03:37:12 GMT

Hi , I have a listbox called City and it has few city names.

I want one button to show or hide if city selection is either Boston or Washington , or both.

so i but the below condition in the button;

=if(GetFieldSelections(City)='Boston' or GetFieldSelections(City)= 'Washington',1,
if(GetFieldSelections(City)='Boston' and GetFieldSelections(City)= 'Washington',1,0))

It works if either one city is selected but do not work if Boston and Washington are selected.

Any thought please.

Thanks,

Ashis

Re: GetFieldSelections with AND condition not working

sultanam — Fri, 10 May 2019 11:16:50 GMT

Hi,

try below one

=if(GetFieldSelections(City)='Boston' or GetFieldSelections(City)='Washington' or
GetFieldSelections(City)='Boston, Washington',1,0)

Regards,

Sultan

Re: GetFieldSelections with AND condition not working

marcus_sommer — Fri, 10 May 2019 11:52:52 GMT

Maybe this approach is more suitable:

wildmatch(concat(distinct City, ','), '*Boston*', '*Washington*')

- Marcus

Re: GetFieldSelections with AND condition not working

sunny_talwar — Fri, 10 May 2019 12:09:42 GMT

You can also try this

Re: GetFieldSelections with AND condition not working

ashis — Fri, 10 May 2019 12:38:30 GMT

Thank you so much, it works.

Re: GetFieldSelections with AND condition not working

ashis — Fri, 10 May 2019 12:39:56 GMT

Thank you for your reply. it works.

Re: GetFieldSelections with AND condition not working

ashis — Fri, 10 May 2019 12:40:51 GMT

Thank you Marcus, it works.

Re: GetFieldSelections with AND condition not working

ashis — Fri, 10 May 2019 12:42:54 GMT

Thank you Sunny, it works also.😁