topic accumulation depending on field comparison in QlikView

accumulation depending on field comparison

Sat, 09 Apr 2011 18:15:17 GMT

Hey everybody,

I'm quite new with Qlikview and ran into the following problem :

I have the following table structure (simplified) :

Table orders :

Table planning

Now I have to build a total of planned_quantity with planned_date < shipping_date.

How do I have to do this with Qlikview, in sql I would use subquerys.

Thanks in advance for your help !

Claus

tresB — Sat, 09 Apr 2011 18:33:48 GMT

Hi,

Did you try this? Sum(If(planned_date<shipping_date, planned_quantity)) as expression.

if your tables are associated as you mentioned, this shoild work.

Regards, tresesco

Sat, 09 Apr 2011 19:15:40 GMT

whow, this has been fast,

yes it looks like working, thanks a lot !

Claus