topic Re: Error in expression in QlikView

Error in expression

patrickbender — Wed, 08 Aug 2018 09:28:56 GMT

=if(IsNull([col1]),

[col2] + [col3],

[col2]+$(var 1))

var 1 = "Set var1 = Aggr(Sum(if(FGLEDG_Bokföringsdatum <= SVDate and Kontogrupp = 'Intäkt',[FGLEDG_BokförtBelopp_SkaBen])), Projektnr);"

FGLEDG_Bokföringsdatum = data from database

SVDate = datefield (inputfield in report)

Kontogrupp = data from database

FGLEDG_BokförtBelopp_SkaBen = data from database

Anonymous — Wed, 08 Aug 2018 09:32:29 GMT

if your code is in same order, the you try to use var1 before defining it

otherwise does QV complains

patrickbender — Wed, 08 Aug 2018 09:43:30 GMT

HI, thank you for your response

the variable is defined in the load script so it should be alright.

‌

marcus_sommer — Wed, 08 Aug 2018 11:53:49 GMT

Try it in this way:

=if(IsNull([col1]), // maybe len(trim(col1)) = 0 as an alternatively ?

[col2] + [col3],

[col2] + $(var1))

Set var1 = "sum(Aggr(Sum(if(FGLEDG_Bokföringsdatum <= SVDate and Kontogrupp = 'Intäkt',[FGLEDG_BokförtBelopp_SkaBen])), Projektnr));"

- Marcus