topic Combobox w/ data from a field in QlikView

Combobox w/ data from a field

papabaer — Wed, 31 Aug 2011 17:53:20 GMT

I need a combobox input control, with values populated from a field. I'd like to take the user-selected value - assign it to a variable, and then use that variable to do more processing etc. I can't seem to find a way to do the 1st part of this: It seems I either have an input box available that makes a 'selection' - which I don't want - or I have an input box that only allows manually-entered, pre-defined values for the input list. Am I missing something obvious? Or is this actually difficult? (I'm accustomed to VBA in Access - and this is simple stuff in that environment...) --- thanks for any help!

Combobox w/ data from a field

Wed, 31 Aug 2011 18:20:11 GMT

Hi ,

correct me if i'm getting it in a wrong way ..,

you mean a multi box with values populated from a field and you wants to save the valus user selected into a variable for further calculations .

if so declare a variable and assign getfieldselections( your field name ) gives you the values which are been selected by users .

thanks

Meher

Combobox w/ data from a field

papabaer — Wed, 31 Aug 2011 19:51:07 GMT

I think you're on the right track... but it looks to me like any of these boxes/controls will automatically apply the selection made by the user. There appears to be no 'generic' UI control - so it seems I will have to use triggers to intercept whenever any change occurs to the multibox - figure out what state it's in, grab the values (if a selection has been made) - undo the selection (again, if appropriate), to be sure I've UNDONE what it wanted to do --- and only then can I proceed with my algorithm to make the selections I want. Sound right? This seems like an awful lot of bookeeping just to ask the user for a value... but then I'm new to QV.

Combobox w/ data from a field

Wed, 31 Aug 2011 19:59:56 GMT

Just a thought ,

If you have two fields in the multi box try to declare two different variables where variable1 grabs selected field in field1 and variables2 does . there is no need to make any undo of selections try to make always 1 selected which helps you to prevent user to make multiple selections in that field . so by making this you can proceed with your algorithm which will have always a value in the variables wich you are using and which will not have any chance to take null values .

Thanks

Meher

Combobox w/ data from a field

papabaer — Wed, 31 Aug 2011 20:05:37 GMT

Interesting - but isn't the user still selecting a field in this case? If so, I still need to undo that selection.

btw - Thanks for your quick responses!

Combobox w/ data from a field

Wed, 31 Aug 2011 20:15:21 GMT

If you know that what value that user is going to select we can trigger to select that value onopening the dashboard or onactivating the sheet, we can trigger a action onopening the sheet and onactivating the sheet to select by using onopen & onactive action which helps you to prevent user to make selections but for that you have to know that the user is gonna be select that specific value

thanks

Meher

Combobox w/ data from a field

papabaer — Wed, 31 Aug 2011 20:36:33 GMT

I'm not sure what you mean. If I knew in advance what the user was going to select, then I wouldn't need the input box... -- and I'd like to stay away from using triggers up at the sheet level if possible since that will slow everything down (I assume...). I think I know what I need to do now - but now I need to figure out what the syntax is to check the state of the multi-box (like what is the syntax for checking (in code) that it has changed or that a selection has been made? I hope the documentation is good - or I'm in for more hair-pulling --- thanks again!

Combobox w/ data from a field

Wed, 31 Aug 2011 20:55:50 GMT

what i mean is , if you have a requirement like always select a top value or 2nd top value or last value or select top of sales etc., which we can trigger but it seems like you doesn't have that sort of requirement

thanks

Meher

Re: Combobox w/ data from a field

Thu, 01 Sep 2011 04:03:49 GMT

Hi,

You can create an Island Field ( A field loaded from resident table in qlikview which doesnt have any relation to the data model but have same data as the source field in the resident table).

So in the front end use this island field to let user select waht ever they want and you update your variables or process the selected data or anything. Being this island field and no relation to main data model user selection will not make any imapct.

Let me know if u have still doubts in getting done this.

Cheers.

Re: Combobox w/ data from a field

papabaer — Thu, 01 Sep 2011 11:18:11 GMT

OK - that sounds like what I'm after - (now to just figure out how to do that...)

thanks much!

Re: Combobox w/ data from a field

Fri, 02 Sep 2011 01:34:43 GMT

Hi,

Glad it helped you.

You can just think of as below:

Data:

Load * Inline [

Country,Prod,Sales

CN,ABC,100

US,DEF,200

IN,GHI,300

];

Selections:

Load distinct Prod as SelectProd resident Data;

Use the SelectProd field in the front end to let users select. To get the selected data you have get.... field... functions in the fron end to process the selected data.

Cheers.

Combobox w/ data from a field

papabaer — Thu, 08 Sep 2011 16:43:54 GMT

Just in case it helps anyone - the way I resolved having that separate list of data was to simply import that same list of data but with a different field name (which keeps it separate). As was noted, this allows the user to make a selection from that list without having any impact on the other data in QlikView.

Thanks again for the help --- After a bit of a learning curve on the next part (learning the syntax for controlling selections etc. through code) - It now works great!