Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

Set expression- date

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

1 Solution

Accepted Solutions

Hi Shamit,

Try,

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

View solution in original post

5 Replies

Hi Shamit,

Try,

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

View solution in original post

Partner
Partner

Hi Shamit,

Try this,

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

Master III
Master III

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

Creator II
Creator II

Hi Shamit,

Please try like this.

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

Partner
Partner

Thanks!

Shamit