Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Error within expression

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 ?

2 Replies
MK_QSL
MVP
MVP

max(Year-1)

should be

Max(Year)-1

malini_qlikview
Creator II
Creator II

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)