topic Re: Selection In List Box Defined With An Expression in QlikView

Selection In List Box Defined With An Expression

ManiSK — Wed, 24 Apr 2019 05:01:09 GMT

Month

Apr 2019

May 2019

Apr 2019|May 2019

I have above list box, now i need to create another list box with month names like below one.

Month names

Apr 2019

May 2019

So now here if i select Apr 2019 from (month names) list box, both Apr 2019 and Apr 2019|May 2019 should get selected from (month) list box and if i select May 2019, both May 2019 and Apr 2019|May 2019.

To achieve the above i tried with below conditions

if (WildMatch(Month,'*Apr*'),'Apr 2019',
if (WildMatch(Month,'*May*'),'May 2019'))

but this works only for Apr 2019 and for May 2019 it selects only May 2019 not selecting Apr 2019|May 2019

could someone help me on this?

Re: Selection In List Box Defined With An Expression

jonathandienst — Wed, 24 Apr 2019 05:09:36 GMT

Using an expression does not work here because when you click on the expression, you are really making a selection on the underlying field. The April/May value maps to April, it cannot map to May as well.

You need to do this in the load script to create a field associated correctly. For example:

Load * Inline
[
	Month, MonthName
	Apr 2019,Apr 2019
	May 2019,May 2019
	Apr 2019|May 2019,Apr 2019
	Apr 2019|May 2019,May 2019
];

Re: Selection In List Box Defined With An Expression

sultanam — Wed, 24 Apr 2019 07:35:32 GMT

Hi Mani,

for achieving below you need to create a Variable in front end. try below one

vMonth = '*' & GetFieldSelections([Month names]) & '*'

Use trigger

setting>>Document>>Triggers>>Variable event trigger>> on change

Trigger: select in field

Field
Month

Search String
=vMonth

then you can select anything from Month name list box you will get your put.

let me know if you face any issue

Re: Selection In List Box Defined With An Expression

ManiSK — Wed, 24 Apr 2019 10:50:12 GMT

Hi Sultanam,

Thanks for you response, tried with that but still not working, facing the same issue.

Re: Selection In List Box Defined With An Expression

sultanam — Wed, 24 Apr 2019 13:47:42 GMT

Hi Mani,

please find the attached file as reference. If you face the same issue let me know.

Re: Selection In List Box Defined With An Expression

ManiSK — Tue, 30 Apr 2019 06:57:10 GMT

It worked perfectly . Thank you so much

Re: Selection In List Box Defined With An Expression

ManiSK — Tue, 07 May 2019 10:31:57 GMT

Hi Sultanam,

I have another query regarding triggers.

In my dashboard, i have multiple containers so now i want to use triggers in containers, is that possible?

Thanks,

Re: Selection In List Box Defined With An Expression

sultanam — Wed, 08 May 2019 09:21:34 GMT

Hi Mani

As per my knowledge there is no option to use trigger on container.

If you have any query kindly post here i will try to help you on that.

Regards,
Sultan