Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set variable value with the selected year on the multibox

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.

7 Replies
jvitantonio
Luminary Alumni
Luminary Alumni

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
Partner - Champion
Partner - Champion

Hi,

     Use this expression

     =GetFieldSelections(Fieldname,',')

Hope it helps

Celambarasan

jagan
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

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
Luminary Alumni
Luminary Alumni

Hi,

Try using the

=Concat(Distinct YearDimensionName, ',')

This will give you Years in comma separated list.

Regards,

Jagan.

Not applicable
Author

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
Luminary Alumni
Luminary Alumni

Hi,

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

Regards,

Jagan.