Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

tosandeep10
Not applicable

Not getting proper result, please hle

Hi Guys,

I have two tables .

   

TABLE A
CODENEED_DATEA
A12-Mar-182
B12-Mar-181
B12-Mar-183

   

TABLE B
CODEDELIVERY_DATEB
A02-Mar-1810
B07-Jan-185
D18-Jul-188

in both tables CODE is the common attribute.

Based on condition where DELIVERY_DATE <= NEED_DATE, I want below result .



   

NEED_DATESUM OF ASUM OF B
12-Mar-18615

Please help .

Thanks

Sandeep

1 Reply
sunny_talwar
Not applicable

Re: Not getting proper result, please hle

May be this

Sum(If(DELIVERY_DATE <= NEED_DATE, A))

Sum(If(DELIVERY_DATE <= NEED_DATE, B))