Set variable value with the selected year on the multibox

[#1]

Hello, I'm a beginner in qlikview and I want to know if this is possible and how can I do it?

I'm trying to get the selected year on the multibox and set to a variable.

Waiting for your answers.

Thanks.

[jvitantonio]

Hi,

Go to menu Settings --> Variable Overview. Create a variable (ADD)  and put:

=GetCurrentSelections(Year)

Save.

Let's say the variable it's call Var. Now create a Text objext and put =Var

[CELAMBARASAN]

Hi,

     Use this expression

     =GetFieldSelections(Fieldname,',')

Hope it helps

Celambarasan

[jagan]

HI,

Create a variable Settings - > Variable Overview -> Add -> Give variable name

and give definition of the variable as

=Max(YearDimensionName)

Hope this helps you.

Regards,

Jagan.

[#5]

Hi, Whe I use these expressions:

=GetCurrentSelections(Year)

=GetFieldSelections(Fieldname,',')

and I reload the script, It give me an error, and show that cannot load the qvds that I'm using in my script.

The problem with this expression:

=Max(YearDimensionName)

Is, If I want to show a total of a group of selected month in the year or a group of selected years I can't do it 'cause it sum the max of the month or year.

Hope that you can help me with this problem.

Thanks

[jagan]

Hi,

Try using the

=Concat(Distinct YearDimensionName, ',')

This will give you Years in comma separated list.

Regards,

Jagan.

[#7]

It works get the information that I need. But What can I do to use it on the script?

Hope you can help me

Thanks

[jagan]

Hi,

Can you explain clearly what you really want.  I can't get you.

Regards,

Jagan.