Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
ManiSK
Contributor II
Contributor II

Selection In List Box Defined With An Expression

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?

1 Solution

Accepted Solutions
sultanam
Contributor III
Contributor III

Hi Mani,

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

View solution in original post

7 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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
];
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
sultanam
Contributor III
Contributor III

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

ManiSK
Contributor II
Contributor II
Author

Hi Sultanam,

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

sultanam
Contributor III
Contributor III

Hi Mani,

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

ManiSK
Contributor II
Contributor II
Author

It worked perfectly . Thank you so much

ManiSK
Contributor II
Contributor II
Author

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,

sultanam
Contributor III
Contributor III

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