topic Re: Error within expression in QlikView

Error within expression

Anonymous — Mon, 05 Oct 2015 13:42:16 GMT

I create two variables

vWeekSelected

=if(IsNull(GetFieldSelections(Week,'*')),Year={$(=max(Year)),Weekyear= {$(=max(Weekyear))})

vLastYearSelected

=if(IsNull(GetFieldSelections(Week,'*')),Year={$(=max(Year-1)),Weekyear= {$(=max(Weekyear-1))})

I declare two expressions

pricethisyear

Sum( {<$(vWeekSelected)>} [Prix de vente TTC])

pricelastyear

Sum( {<$(vLastYearSelected)>} [Prix de vente TTC])

pricethisyear and pricelastyear return the same value which is wrong . How to correct it ?

MK_QSL — Mon, 05 Oct 2015 13:44:59 GMT

max(Year-1)

should be

Max(Year)-1

malini_qlikview — Mon, 05 Oct 2015 14:07:34 GMT

Hi,

The set modifier is not ended properly for Year parameter, use the below

vWeekSelected=if(IsNull(GetFieldSelections(Week,'*')),Year={$(=max(Year))},Weekyear= {$(=max(Weekyear))})

vLastYearSelected

=if(IsNull(GetFieldSelections(Week,'*')),Year={$(=max(Year-1))},Weekyear= {$(=max(Weekyear-1))})

Also please check if the field names are used correct (Case sensitive)