topic Regarding Variables in QlikView

Regarding Variables

Tue, 08 Dec 2009 19:04:28 GMT

Hi All,

I want to put the selected value of listbox into a variable. Can i do that?

Waiting for your reply

Thanks in advance

Tue, 08 Dec 2009 19:31:33 GMT

Hi,

if you just select one single value you can use "=FieldName" as variablevalue. But i think, you select more then one, don´t you?

Kind regards.

Tue, 08 Dec 2009 19:46:14 GMT

Depends what you need to do with your variable. Showing selections in a text object is as simple as

=GetFieldSelections(field)

Tue, 08 Dec 2009 19:51:36 GMT

Set the variable value =CONCAT(FieldName, ';') and you will receive all selected records in one line separated by ;

Tue, 08 Dec 2009 19:54:30 GMT

hi adamvaughan,

Using =GetFieldSelections(field) will show something like "20 of 3032" for large selections.

Tue, 08 Dec 2009 19:55:27 GMT


luciaN wrote:
Set the variable value =CONCAT(FieldName, ';') and you will receive all selected records in one line separated by ;<div></div>

That´s nice. I haven´t known this opinion before.

Tue, 08 Dec 2009 20:40:29 GMT

Hi All,

Thanks for your quick replies. I have one more doubt.

How can i implement the =GetFieldSelections(field) within a macro??

Thanks,

Rajesh

Tue, 08 Dec 2009 22:16:57 GMT

Its true that you do get "x of y" however I dont know how many things are being selected 😉

What we need here is the requirement - its not clear what is being selected nor what to do with those values.

If you search this forum for "loop" you should find a working example similar to this:

set myListBox= ActiveDocument.GetSheetObject("LB01")
myValues=myListbox.GetPossibleValues

for mycounter = lbound(myValues) to ubound(myValues)
ActiveDocument.Fields("TheFieldUsedinLB01").Select myValues(mycounter )