topic Re: Set expression- date in QlikView

Set expression- date

shamitshah — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the following two expressions. The first one works , but the second one does not.

sum(if(DueDate>Today(), OrderedUnits))

AGGR(SUM({<DueDate={">today()"}>}OrderedUnits),[Item Number])

Appreciate your help.

Shamit

tamilarasu — Wed, 15 Jun 2016 03:57:49 GMT

Hi Shamit,

Try,

AGGR(SUM({<DueDate={">$(=today())"}>}OrderedUnits),[Item Number])

susovan — Wed, 15 Jun 2016 04:17:44 GMT

Hi Shamit,

Try this,

=AGGR(SUM({<DueDate={">=$(=Today())"}>}OrderedUnits),[Item Number])

sujeetsingh — Wed, 15 Jun 2016 04:18:32 GMT

AGGR(SUM({<DueDate={">$(=today())"}>}OrderedUnits),[Item Number])

lalitkgehlot89 — Wed, 15 Jun 2016 04:45:04 GMT

Hi Shamit,

Please try like this.

=aggr(sum({<duedate={">$(=today())"}>}OrderUnits),[Item Number])

shamitshah — Wed, 15 Jun 2016 05:15:58 GMT

Thanks!

Shamit