topic Script variables as fixed string in QlikView

Script variables as fixed string

Wed, 31 Aug 2016 07:53:14 GMT

Good morning,

I have

set DC_Ind_Budget = 'C';

and then

MyTable:
load
$(DC_Ind_Budget)) as [Debit / Credit Indicator];

This results in error "Field not found - <C>". The following doesn´t work neither

''' & $(DC_Ind_Budget)) & ''' as [Debit / Credit Indicator];

Thanks in advance for your suggestions,

Leonardo

Anonymous — Wed, 31 Aug 2016 07:58:01 GMT

try

MyTable:
load
'$(DC_Ind_Budget))' as [Debit / Credit Indicator];

cesaraccardi — Wed, 31 Aug 2016 08:14:01 GMT

Hi,

Also check the closing parenthesis at the end, looks like you have one extra.

MyTable:
load
'$(DC_Ind_Budget)' as [Debit / Credit Indicator];

sunny_talwar — Wed, 31 Aug 2016 08:25:20 GMT

Or you can do this:

SET DC_Ind_Budget = Chr(39) & 'C' & Chr(39);

MyTable:
LOAD $(DC_Ind_Budget) as [Debit / Credit Indicator];