Set variable to field value in load script

[#1]

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!

[bbi_mba_76]

Hi,

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

[Clever_Anjos]

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

[#4]

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

[#5]

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

[#6]

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

[#7]

Hi,

Check this,

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

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

Regards,

Ravikant

[#8]

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?

[#9]

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

[#10]

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