Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
Valued Contributor III

Set variable value with the selected year on the multibox

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

Hi,

     Use this expression

     =GetFieldSelections(Fieldname,',')

Hope it helps

Celambarasan

MVP
MVP

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

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

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

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


MVP
MVP

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

Hi,

Try using the

=Concat(Distinct YearDimensionName, ',')

This will give you Years in comma separated list.

Regards,

Jagan.

Not applicable

Set variable value with the selected year on the multibox

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

MVP
MVP

Set variable value with the selected year on the multibox

Hi,

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

Regards,

Jagan.

Community Browser