topic Not able to hold value in variable in QlikView

Not able to hold value in variable

jagannalla — Fri, 01 Jul 2011 05:19:22 GMT

Hi,

- In the list box i've a Group field and with presentaion as check box. After marking the data i'll click the button to store the data in variable.

- Button contains the action like following:

variable : vGroup

value: =GetFieldSelections(Group,',')

- Now the variable contains the data. But if selected data is greater than 6 the variable not able to hold the data.

I don't know y it happening can anybody solve this problem.

I'm attaching sample qvw file...But i'm using personal edition.

Not able to hold value in variable

Anonymous — Fri, 01 Jul 2011 05:43:50 GMT

Hi Jacq,

The GetFieldSelections() function has a 3rd parameter as well (default value is 6) for number of selections to record.

You can put another number in there to capture more selections, like:

=GetFieldSelections(Group,',',20)

Not able to hold value in variable

jagannalla — Fri, 01 Jul 2011 05:55:05 GMT

Johannes Sunden,

Ya..It's woking thanks a lot.

Not able to hold value in variable

Anonymous — Fri, 01 Jul 2011 05:56:02 GMT

No worries, glad to hear it's working fine for you.

Not able to hold value in variable

jagannalla — Sat, 02 Jul 2011 10:24:12 GMT

Johannes Sunden,

Small fare from you if list box is with expression how can i store selected values into variable. B'coz if listbox is with expression then this code:=GetFieldSelections(Group,',',20) is not working to store selections into variable.

Not able to hold value in variable

jagannalla — Sat, 23 Jul 2011 09:35:52 GMT

Is it possible to store unselected data of listbox in one variable..

i.e.., reverse to this code =GetFieldSelections(Group,',',20)