accumulation depending on field comparison

[#1]

Hey everybody,

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

I have the following table structure (simplified) :

Table orders :

• order_id
• part_id
• order_quantity
• shipping_date

Table planning

• part_id
• planned_quantity
• planned_date

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

[tresesco · Accepted solution]

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

[#3]

whow, this has been fast,

yes it looks like working, thanks a lot !

BR

Claus