topic Re: Set variable to field value in load script in QlikView

Set variable to field value in load script

Wed, 27 Nov 2013 13:41:03 GMT

Hi all.

Is there anyone that could explain how I could set av varibale in my load script (SET Current_FC = BudgetType=('FC2 2013');) and then use the variable in a set analysis like:

sum({$<PeriodCounter={"$(#=max(PeriodCounter-1))"}, $(Current_FC) ,Cost_Center_ID-={'10600'}>} BudgetAmount) *-1/1000

Thanks in advance!

Re: Set variable to field value in load script

bbi_mba_76 — Wed, 27 Nov 2013 15:30:30 GMT

Hi,

maybe this post could help you Setting a variable in script...

Re: Set variable to field value in load script

Clever_Anjos — Wed, 27 Nov 2013 15:43:51 GMT

May this http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/18/dollar-expansions can solve your problem

Re: Set variable to field value in load script

Fri, 29 Nov 2013 09:42:58 GMT

Thanks for reply. Unfortunately I did'nt find anything that solve my problem...

Re: Set variable to field value in load script

Fri, 29 Nov 2013 09:43:06 GMT

Thanks for reply. Unfortunately I did'nt find anything that solve my problem...

Re: Set variable to field value in load script

Fri, 29 Nov 2013 09:50:39 GMT

I would change a little the sentence for setting the variable:

SET Current_FC = BudgetType={'FC2 2013'}

Use curly brackets. In fact your variable should contain a true part of the set analysis syntax

Perhaps, also, use quotes: set Current_FC = "xxxx"; (due to the = sign in your text also)

Fabrice

Re: Set variable to field value in load script

Fri, 29 Nov 2013 09:54:23 GMT

Hi,

Check this,

http://community.qlik.com/message/357969#357969

http://community.qlik.com/message/370872#370872

Regards,

Ravikant

Re: Set variable to field value in load script

Tue, 03 Dec 2013 12:42:53 GMT

Yes, I get the right value (BudgetType={'FC2 2013'}) for the variable if I look in the Variable Overview...

But i don't get the calculation right the I have the expression like this:

sum({$<PeriodCounter={"$(#=max(PeriodCounter-1))"}, BudgetType={$(Current_FC)} ,Cost_Center_ID-={'10600'}>} BudgetAmount) *-1/1000

Any suggestions?

Re: Set variable to field value in load script

Tue, 03 Dec 2013 12:54:37 GMT

It seems correct. I would try to enclose the variable between quotes or brackets because there is a space (special character):

BudgetType = {[$(Current_FC)] }

Fabrice

Re: Set variable to field value in load script

Mon, 09 Dec 2013 14:00:16 GMT

Thanks for reply! But it still doesn't work, I only get 0. Do you have any other suggestions?

Re: Set variable to field value in load script

karolina_ — Mon, 09 Dec 2013 14:16:30 GMT

have you tried just SET Current_FC = 'FC2 2013';

because with {'FC2 2013'} you have double brackets BudgetType={{'FC2 2013'}}

or try
SET Current_FC = FC2 2013;

and then BudgetType={'$(Current_FC)'}>

Re: Set variable to field value in load script

Fri, 13 Dec 2013 09:56:26 GMT

Thanks for your reply en the solution thats works for me is:

In the script - SET Current_FC = 'FC2 2013';

In the expression - BudgetType={[$(Current_BC)]}