topic Re: Select available value in a list box in QlikView

Select available value in a list box

Thu, 01 Mar 2012 19:57:24 GMT

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.

Re: Select available value in a list box

mdmukramali — Thu, 01 Mar 2012 21:11:58 GMT

Dear,

Find the attachment of the sample application of your requirement.

Thanks,

Mukram.

Re: Select available value in a list box

Fri, 02 Mar 2012 01:18:28 GMT

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.

Re: Select available value in a list box

CELAMBARASAN — Fri, 02 Mar 2012 04:31:07 GMT

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

Re: Select available value in a list box

mdmukramali — Fri, 02 Mar 2012 06:17:14 GMT

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

Re: Select available value in a list box

Fri, 02 Mar 2012 13:43:30 GMT

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