topic Re: Extracting future PO Deliveries in QlikView

Extracting future PO Deliveries

Thu, 12 Nov 2015 23:19:18 GMT

sum({$<[Purchase Required Date]={">=$(=Now())">}[Purchase Ordered FC Value])

What is wrong with this expression?

I am attempting to sum all PO's with a required delivery date greater than today.

thank you!

Re: Extracting future PO Deliveries

tamilarasu — Fri, 13 Nov 2015 04:18:02 GMT

Hi Craig,

You missed Paranthesis

=sum({$<[Purchase Required Date]={">=$(=Date(today(),'DD/MM/YYYY'))"}>}[Purchase Ordered FC Value])

Change the data format according to the Purchase Required Date format.

Let me know.

Re: Extracting future PO Deliveries

jonas_rezende — Fri, 13 Nov 2015 13:08:41 GMT

Hi, Craig.

The Now() function

returns a timestamp of the current time from the system clock. Ex.: 11/13/2015 11:06:45

So, you have of format for date. Use function Date(). Ex.:

sum({$<[Purchase Required Date]={">=$(=Date(Now()))">}[Purchase Ordered FC Value])

Hope this helps!

Re: Extracting future PO Deliveries

Fri, 13 Nov 2015 17:27:22 GMT

Unfortunately I am still doing something wrong. My data looks like this without the filtering:

Purchase Required Date

Purchase Order Num

Item Group

Item Code

03/01/2016

46727

Foil

00047X24

17340

03/01/2016

46728

Foil

00045X2350 8079

14859

02/18/2016

45825

Misc Supplies

Misc

920

02/15/2016

46472

Foil

0004X2450 8079

61180

My expression is:

=sum({$<[Purchase Required Date]={">=$(=Date(Now()))">}[Purchase Ordered FC Value])

I believe I have attached the file.

Any suggestions?

Re: Extracting future PO Deliveries

maxgro — Fri, 13 Nov 2015 20:11:10 GMT

=sum({$<[Purchase Required Date]={">=$(=Date(Now()))"}>} [Purchase Ordered FC Value])

Re: Extracting future PO Deliveries

Fri, 13 Nov 2015 20:21:57 GMT

Thank you. That was the answer.