topic Re: select specific value for filters in QlikView

select specific value for filters

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

Hi experts!

I have a list of different filters/listboxes as follows:

Mgr1Open

Mgr2Open

Mgr3Open

Mgr1Resp

Mgr2Resp

Mgr3Resp

Mgr1Cls

Mgr2Cls

Mgr3Cls

And i have a MgrTypes field as 'O' for *Open, 'R' for *Resp and 'C' for *Cls

What should be the right expression for each Mgr filter above that when i select one, it will correspond to the right MgrType (eg. If i select Mgr1Resp, Mgr2Resp or Mgr3Resp only MgrType 'R' is selected)

Thanks in advance!

Re: select specific value for filters

fvelascog72 — Thu, 14 Sep 2017 09:05:01 GMT

Hi,

I think I don't understand your problem.

Try with my app.

Saludos.

Re: select specific value for filters

effinty2112 — Thu, 14 Sep 2017 09:08:10 GMT

Hi Preciosa,

In Settings \ Document Properties create a Field Event Trigger on selection of the field Mgr.

Good luck

Andrew

Re: select specific value for filters

its_anandrjs — Thu, 14 Sep 2017 09:12:51 GMT

Do you have any type field.

Re: select specific value for filters

its_anandrjs — Thu, 14 Sep 2017 09:15:35 GMT

It seems you have MgrTypes field if so then try this in Field Event trigger

MgrTypes

=Wildmatch(MgrTypes,'*R*')

=Mixmatch(MgrTypes,'*R*')

=Match(MgrTypes,'*R*')