Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Select available value in a list box

Hi, I have a list box with the values (a1,a2,a3...a50). In a moment only the values (a1, a3, a5, a22, a32, a41, a49) are available. In other moment the values are (a5, a6, a34, a35, a36), etc.

I have 5 buttons with the labels: A1 - A2 - A3 - A4  and A5

If you clic in A1 button, the value 'a1' must select in the list box, BUT only if the value is available in that moment, if you clic in A4 button the value 'a4' must select in the list box, BUT only if the value is available in that moment.

I think that a macro must be used.

Thanks.

1 Solution

Accepted Solutions
Not applicable

Re: Select available value in a list box

Here it's the solution. I used macros. Please view the attachment.

5 Replies
mdmukramali
Not applicable

Re: Select available value in a list box

Dear,

Find the attachment of the sample application of your requirement.

Thanks,

Mukram.

Not applicable

Re: Select available value in a list box

Please look the attachchment.

If I clic in the button 'Mon', I want to select a1 in the List Box, but only if the value a1 is available in that moment, if the value a1 isn't available then don't do nothing.

If I clic in button 'Sun', I want to select in the List Box the value a7, but only if the value a7 is available in that moment, if the value a7 isn't available then don't do nothing.

Thanks.

celambarasan
Not applicable

Re: Select available value in a list box

Hi,

Try this as search string

     =if(WildMatch(Concat(FieldName,','),'*a1*')=1,'a1',Concat(FieldName,',')) for a1 selection button replace a1 as some other values as your need.

Celambarasan

mdmukramali
Not applicable

Re: Select available value in a list box

Dear,

find the attchment..

if you click on Mon Button it will select Mon from list box Day and Select a the Related Values from Id to the Mon.

Thanks,

Mukram

Not applicable

Re: Select available value in a list box

Here it's the solution. I used macros. Please view the attachment.