Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
whow, this has been fast,
yes it looks like working, thanks a lot !
BR
Claus