topic Set variable value with the selected year on the multibox in QlikView

Set variable value with the selected year on the multibox

Thu, 23 Feb 2012 14:14:14 GMT

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.

Set variable value with the selected year on the multibox

jvitantonio — Thu, 23 Feb 2012 14:19:41 GMT

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

Set variable value with the selected year on the multibox

CELAMBARASAN — Thu, 23 Feb 2012 14:24:42 GMT

Hi,

Use this expression

=GetFieldSelections(Fieldname,',')

Hope it helps

Celambarasan

Re: Set variable value with the selected year on the multibox

jagan — Thu, 23 Feb 2012 14:24:51 GMT

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.

Re: Set variable value with the selected year on the multibox

Thu, 23 Feb 2012 15:11:02 GMT

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

Re: Set variable value with the selected year on the multibox

jagan — Thu, 23 Feb 2012 15:19:43 GMT

Hi,

Try using the

=Concat(Distinct YearDimensionName, ',')

This will give you Years in comma separated list.

Regards,

Jagan.

Set variable value with the selected year on the multibox

Fri, 24 Feb 2012 13:31:19 GMT

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

Set variable value with the selected year on the multibox

jagan — Fri, 24 Feb 2012 14:58:21 GMT

Hi,

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

Regards,

Jagan.