topic Re: Using variable in a dynamic way in QlikView

Using variable in a dynamic way

Mon, 25 Mar 2013 21:16:09 GMT

Hello
Experts,

I’m having
a problem with variable.

I have lots of variable like Var10, Var20, Var30, ect… and I want to use these variable in a dynamic way:

10, 20, 30, and so on is a filed value (fieldx) and I’d like to use the field value define variable name and to find variable value.

If field value is 10, I want to use $(Var10),

If field value is 20, I want to use $(Var20),

Is it possible?

I’ve tried with $(=’Var’&fieldx), but ’Var’&fieldx is correct, while $(=’Var’&fieldx) doesn’t work.

Can anyone help me?

Thank you

Re: Using variable in a dynamic way

Mon, 25 Mar 2013 21:27:08 GMT

Have you tried creating a new variable that is 'Var'&fieldx and then referencing that variable instead? That way you would be referencing $(newVariable) instead of $(=’Var’&fieldx). I haven't tried it, but it's just a suggestion off the top of my head.

Re: Using variable in a dynamic way

jeffmartins — Mon, 25 Mar 2013 23:20:14 GMT

Hi cristina.pasqualucci,

You need to use same temporary variables to do this.

See the attached file. Hope this helps you.

Regards

Re: Using variable in a dynamic way

Tue, 26 Mar 2013 06:38:37 GMT

Hello cristina,

It will work this way:

=$(=('Var'&fieldx))

Thanks,

itsangad

Re: Using variable in a dynamic way

advait_thakur — Tue, 26 Mar 2013 06:56:57 GMT

Hello Christina,

What you have tried is correct..$(=’Var’&fieldx)

will you please try using = prior to this.

Like =$(=’Var’&fieldx)

Thanks

Advait

Re: Using variable in a dynamic way

Tue, 26 Mar 2013 08:41:36 GMT

Thank you all!

Unfortunately, these are not ok.

what do you think about using if statement?

if (fieldx = '10', &(Var10),

if(fieldx = '20', &(Var20), ......))))

do you think this will slow the document?

Many Thanks

cristina

Re: Using variable in a dynamic way

Tue, 26 Mar 2013 11:13:09 GMT

Hello Cristina,

Do you need dynamic values at the script level or chart level.

Though =$(=('Var'&fieldx)) works fine at chart level.

Yes you can use the if statement as well. As per my understanding, it should not effect much.

thanks,

itsangad

Re: Using variable in a dynamic way

Tue, 26 Mar 2013 11:20:12 GMT

Hello,

I need it at chart level.

I try with if statement.

Thank you.

cristina

Re: Using variable in a dynamic way

jagan — Tue, 26 Mar 2013 11:29:21 GMT

Hi,

Try this, if your field values are exactly multiples of 10 (i.e., 10, 20, 30.......)

=Pick(FieldValue/10, $(Var10), $(Var20), $(Var30))

Hope this helps you.

Regards,

Jagan.

Re: Using variable in a dynamic way

Tue, 26 Mar 2013 11:44:05 GMT

Hello,

Can you upload your qvw.

thanks,

itsangad

Re: Using variable in a dynamic way

Tue, 26 Mar 2013 14:44:16 GMT

Hi,

I solved using If statement.

Thank you

Cristina