topic Re: conditional show expression based on listbox selection in QlikView

conditional show expression based on listbox selection

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

I want to be able to conditionally display my expressions based on my list box selections. I've tried using wildmatch but can't get each expression to respond independently.

I want the following conditions to apply

Only 'Sales' selected = display only Sales expression

Only 'L12 Sales' selected = display only 'L12 Sales' expression

Both selected = show both selections

The opposite result for when they are not selected.

At the moment I'm struggling as when L12 Sales is selected/deselected both L12 Sales and Sales respond

In the future I have will have multiple selection options with 'sales' in the name. I will want all expressions to be controlled independently by one selection each only.

Re: conditional show expression based on listbox selection

tresB — Fri, 08 Jun 2018 09:50:44 GMT

Try below expressions

=WildMatch('@'&GetFieldSelections(subheader, '@')&'@','*@Sales@*')

=WildMatch('@'&GetFieldSelections(subheader, '@')&'@','*@L12 Sales@*')

Re: conditional show expression based on listbox selection

robmarr789 — Fri, 08 Jun 2018 10:03:54 GMT

What does that mean?

Re: conditional show expression based on listbox selection

tresB — Fri, 08 Jun 2018 10:07:51 GMT

This is to put some extra character between values so that 'Sales' could be separated from a values like 'XXXSalesYYY'. Is it not working as desired for you?

Re: conditional show expression based on listbox selection

robmarr789 — Fri, 08 Jun 2018 10:45:42 GMT

Brilliant that works. Any change you could explain the logic through each step?

Sorry I'm very new to QV

Re: conditional show expression based on listbox selection

Nakosan — Tue, 22 Nov 2022 16:22:20 GMT

Hey, do you see what I'm doing wrong with combining WildMatch?

If(WildMatch(nativeCode, 1, 2, 3, ),'Minor severity'),

If(WildMatch(nativeCode, 4, 5, 8, ),'Medium severity'),

If(WildMatch(nativeCode, 7, 6, 9, ),'Critical'),

Have tried with = instead of If, also some other expressions... Shouldn't be too hard but been stuck on this for a while now.

Re: conditional show expression based on listbox selection

tresB — Wed, 23 Nov 2022 04:51:14 GMT

Hi @Nakosan ,

It could be the nesting structure issue. Try instead like (note the bracket changes):

If(WildMatch(nativeCode, 1, 2, 3, ),'Minor severity',

If(WildMatch(nativeCode, 4, 5, 8, ),'Medium severity',

If(WildMatch(nativeCode, 7, 6, 9, ),'Critical')))