topic always select one value in multibox setting in script or events in QlikView

always select one value in multibox setting in script or events

Wed, 15 Feb 2012 17:15:02 GMT

Hi,

I am having two tabs in my dashboard. in one tab i need to select one value always.

when i am moving to second tab i need to clear all the fields. when i come back to first sheet i need to select one value always. If i set this value in Multibox--> Presention--> always select one value , i can't clear the values when i am moving to 2nd TAB.

Please help.

Thanks,

Suresh

always select one value in multibox setting in script or events

deepakk — Wed, 15 Feb 2012 17:30:07 GMT

hi,

You need to create trigger on active sheet event.,

Right click on the sheet --> go to trigger --> Add action -- > Selection -->Select in field --

Specify the field name and value..

you might have to play around with = to sign.. I dont remember if we have to add the equal to sign or not

I hope this solves yyour problem.

Deepak

always select one value in multibox setting in script or events

Wed, 15 Feb 2012 17:37:42 GMT

That thing i did. it is selectting one value, but in this case i can select multiple options in the field. but i want to restrict the multi selection on the field.

Re: always select one value in multibox setting in script or events

Anonymous — Thu, 16 Feb 2012 07:36:59 GMT

Hi suresh

We can achieve the solution for your problem using the macro .

Hope the attached file will be helpful for your problem

Regards

Ashok