Issue in variable import

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to import an expression through an external text file which has some variables in the expression. However it is not able to replace the variable value inside the expression. Details below:

Variable to be imported

SET vCurrentVolumeTRx

= sum({<[Time_Vlookup.Month End Date]={">=(=$(vTrendStart))<=($(=vTrendEnd))"},[Time Bucket Type]={'Current'},[CAL_SRC]={'Sales'}>} if([Time_Vlookup.Month End Date]=[Month End Date],TRX_NORM));

Definition of variables used in the above expression

SET vTrendStart	=	min({<[Time_Vlookup.Time Bucket Name]=P([Time Bucket Name]), [Time_Vlookup.Time Bucket Type] = P([Time Bucket Type])>}[Time_Vlookup.Month End Date]) ;
SET vTrendEnd	=	max({<[Time_Vlookup.Time Bucket Name]=P([Time Bucket Name]), [Time_Vlookup.Time Bucket Type] = P([Time Bucket Type])>}[Time_Vlookup.Month End Date]) ;

I am getting the expression after import.

sum({<[Time_Vlookup.Month End Date]={">=<="},[Time Bucket Type]={'Current'},[CAL_SRC]={'Sales'}>} if([Time_Vlookup.Month End Date]=[Month End Date],TRX_NORM))

Appreciate your help.

Regards,

Sam

topic Issue in variable import in QlikView

Issue in variable import