topic Re: Error is Expression in QlikView

Error is Expression

helen_pip — Wed, 06 Jan 2016 10:16:33 GMT

Hello,

I have written an expression which is unfortunately returning a 0 value, however I know I am expecting a higher value than 0

Could someone kindly take a look at the syntax and let me know if I have put in too many brackets, or not enough commas etc

Any help would be greatly appreciated

SUM({$<FactDateNum =

{">=$(=date(makeweekdate(year(now()),week(now()))))<=$(=(date(makeweekdate(year(now()),week(now()))+6)))"}>}

QuarterlyBreaches_Attendance_ID)

MK_QSL — Wed, 06 Jan 2016 10:19:17 GMT

What is the format of FactDateNum ?

PrashantSangle — Wed, 06 Jan 2016 10:21:35 GMT

Hi,

Check your expression in text object

=date(makeweekdate(year(now()),week(now())))

and

=(date(makeweekdate(year(now()),week(now()))+6))

Looks like you have bracket issue in second expression

Regards

MayilVahanan — Wed, 06 Jan 2016 10:25:49 GMT

Hope that FactDateNum contains the date in number format.

Try like this

SUM({$<FactDateNum =

{">=$(=Floor(date(makeweekdate(year(now()),week(now()) ))))<=$(=Floor(date(makeweekdate(year(now()),week(now()))+6)))"}>}

QuarterlyBreaches_Attendance_ID)

Edit: Instead of Now() , please use Today() ..