topic Re: Incorrect expression in QlikView

Incorrect expression

Anonymous — Mon, 31 Aug 2015 11:28:51 GMT

I am looking to make a sum of PrixVente when [Structure] ={'1174*'} and for the last year ,

the following expression returns wrong values , how to correct it ?

=if(IsNull(GetFieldSelections(Week,'*')),Sum({$<Year={$(=max(Year-1))}>}{<[Structure] ={'1174*'}>}PrixVente)

,Sum({$<Weekyear= {$(=max(Weekyear-1))}>}{<[Structure] ={'1174*'}>}PrixVente))

Re: Incorrect expression

sushil353 — Mon, 31 Aug 2015 11:34:52 GMT

Try :

=if(IsNull(GetFieldSelections(Week)),Sum({$<Year={'$(=max(Year)-1)'} ,[Structure] ={"1174*"}>}PrixVente)

,Sum({$<Weekyear= {'$(=max(Weekyear)-1)'},[Structure] ={"1174*"}>}PrixVente))

HTH

Re: Incorrect expression

qlikmsg4u — Mon, 31 Aug 2015 11:35:50 GMT

try this

=if(IsNull(GetFieldSelections(Week)),Sum({$<Year={$(=(max(Year)-1))}>}{<[Structure] ={'1174*'}>}PrixVente)

,Sum({$<Weekyear= {$(=(max(Weekyear)-1))}>}{<[Structure] ={'1174*'}>}PrixVente))

Re: Incorrect expression

maxgro — Mon, 31 Aug 2015 11:36:54 GMT

I think

=Sum( {$ <Year={$(=max(Year)-1)},Structure ={"1174*"}>} PrixVente)

same for WeekYear

Re: Incorrect expression

jonathandienst — Mon, 31 Aug 2015 11:56:04 GMT

The above posts correct the syntax error in your expression.

What is the format of Weekyear? Is it text or numeric? The QV Weekyear function returns a year value.

If weekyear means the week number in the year, then max(Weekyear) will not work correctly over the year end (week1 - 1 = week52 of prior year). You need to do proper date calculation - do you have a date field?

Re: Incorrect expression

Anonymous — Mon, 31 Aug 2015 12:33:34 GMT

HI,

Try this:

=if(IsNull(GetFieldSelections(Week,'*')),Sum({<Year={'$(=max(Year)-1)'},[Structure] ={'1174*'}>}PrixVente)

,Sum({<Weekyear= {'$(=max(Weekyear)-1)'},[Structure] ={'1174*'}>}PrixVente))