syntax problem

Sat, 02 May 2015 03:10:36 GMT

Hi all,

I am trying to change an expression into the variable in load script . but The expression doesnt work when I try to change it to variable

Can some one please tell me what is wrong with this script?

LET vExecutionSummaryIntakeOrder = 'sum(if([NB_Execution_Summaries_Table.sort order]={10},[NB_Execution_Summaries_Table.Order intake today]))';

LET vExecutionSummaryShmtToday = 'sum(if([NB_Execution_Summaries_Table.sort order]={10},[NB_Execution_Summaries_Table.Shmt today]))';

Re: syntax problem

tresB — Mon, 04 May 2015 10:47:10 GMT

It looks okay. Only thing you have to be careful about is while using this variable, use with '$' symbol, i.e. call this variable like $(vExecutionSummaryIntakeOrder)

And yes, there is a catch, why are you using '{}' while comparing? Try without it like:

LET vExecutionSummaryIntakeOrder = 'sum(if([NB_Execution_Summaries_Table.sort order]=10,[NB_Execution_Summaries_Table.Order intake today]))';

topic syntax problem in QlikView

syntax problem

Re: syntax problem