topic For each .. syntax for values starting with a number in QlikView

For each .. syntax for values starting with a number

joris_lansdaal — Mon, 12 Sep 2016 12:34:28 GMT

Hi All,

I've got a syntax issue i can't solve. Below script gives an error on '10Y_ABND_costs'; because it starts with a number.

I've tried Double quotes, brackets and combinations, but then there's no match with my PNL_Lines value.

Can anyone help me with the right syntax for this value '10Y_ABND_costs'?

FOR Each b in ....,'10Y_ABND_costs',.....
       Concatenate(Budget)
            Load PnL_Lines,
              .......
            Bedrag as $(b),
             .......
              resident Budget_Temp
             Where PnL_Lines='$(b)' ;
Next

drop tables Budget_Temp;

Re: For each .. syntax for values starting with a number

sunny_talwar — Mon, 12 Sep 2016 12:37:19 GMT

May be this:

FOR Each b in ....,'10Y_ABND_costs',.....

Concatenate(Budget)

Load PnL_Lines,

.......

Bedrag as [$(b)],

.......

resident Budget_Temp

Where PnL_Lines = '$(b)' ;

Next

Re: For each .. syntax for values starting with a number

joris_lansdaal — Mon, 12 Sep 2016 12:42:44 GMT

Thanks Sunny.