topic Re: Set Analysis Syntax - DATE in QlikView

Set Analysis Syntax - DATE

brucejensen — Fri, 18 Jul 2014 21:38:53 GMT

I need to sum my Cost field for all values in the set where the date field is prior to the current date. I tried the following but am not getting any results (evaluates to 0). Can someone help me with the syntax?

=sum({1<Date={"<=$(=DATE(MAX(Date)))"}>Cost)

I had this working at one point then lost it and now I can't get it to work again.

Thanks!

Re: Set Analysis Syntax - DATE

Fri, 18 Jul 2014 21:44:47 GMT

Hi Bruce,

You're missing the closing } before Cost.

Re: Set Analysis Syntax - DATE

MK_QSL — Fri, 18 Jul 2014 22:53:35 GMT

=sum(

{1<

Date={"<=$(=DATE(MAX(Date)))"

}>}

Cost)

Re: Set Analysis Syntax - DATE

Sat, 19 Jul 2014 07:06:17 GMT

see the below code and hopefully it will work out for your issue.

=sum(

{1<

Date={"<=$(=DATE(MAX(Date)))"

}>}

Cost) }

Re: Set Analysis Syntax - DATE

brucejensen — Mon, 21 Jul 2014 18:13:03 GMT

Sorry - Still not working. Still evaluates to 0.

Re: Set Analysis Syntax - DATE

brucejensen — Mon, 21 Jul 2014 18:13:40 GMT

Still comes up as zero for an answer.

Re: Set Analysis Syntax - DATE

santharubban — Mon, 21 Jul 2014 19:00:42 GMT

try this

=sum({1<Date={'<=$(=DATE(MAX(Date)))'}>} Cost) }

Re: Set Analysis Syntax - DATE

brucejensen — Mon, 21 Jul 2014 19:01:51 GMT

Thanks!