topic Re: Listbox help with Expression in Field in QlikView

Listbox help with Expression in Field

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

Hello,

I am trying to filter a data set by relationship: Related or Unrelated.

My data set does not have this parameter included however the logic to determine this is if "rel" is located in the Name.

I am trying to write an expression in a list box to have this behave accordingly.

If Related is selected, then I would like to see that logic applied to the other selections and vice versa if Unrelated is selected.

Any help would be greatly appreciated!

Re: Listbox help with Expression in Field

vishsaggi — Mon, 17 Sep 2018 17:21:23 GMT

What is the field name for your listbox and what are the values this lisbox holds now? Are there only two values like Related and Unrelated or you want to search a string in this field for Rel and Unrel values? Can you elaborate with an eg so that we can help you quickly. ?

Re: Listbox help with Expression in Field

tom906123 — Wed, 19 Sep 2018 16:36:53 GMT

Field Name is clientname

The table for this field looks something like this

clientname|

abcdrel

abcrel123

xyz321

I would like two values in the List Box: Related and Unrelated

If I select Related, I would like to results for all client names with "rel" in it.

Thanks so much the help!

Re: Listbox help with Expression in Field

vishsaggi — Wed, 19 Sep 2018 17:25:47 GMT

write this in your listbox in general tab Field - Expression

= IF(WildMatch(clientname, '*rel*')>0, 'Related', 'Unrelated')

Re: Listbox help with Expression in Field

tom906123 — Wed, 19 Sep 2018 18:48:10 GMT

Many thanks!! Worked like a charm