Expression trouble

Mon, 26 Jan 2026 18:19:17 GMT

I have an expression in my pivot chart - sum(if(date_received<=expected_date, qty_received))

I tried putting this in my script rather than have the calculations eating memory in the pivot:

NOCONCATENATE LOAD

order_no,

if(date_received<=expected_date, qty_received) as itemsOnTime

RESIDENT op;

This loads correctly, however when the value "itemsOnTime" is in the pivot I'm getting a 0 value.

But when the expression sum(if(date_received<=expected_date, qty_received)) is in the pivot I receive the corrrect calculation.

Can anyone see anything wrong here? Thanks in advance...

erichshiino — Wed, 22 Jun 2011 11:38:49 GMT

Are the numbers there when you put itemsonTime in a listbox?

I guess you should use sum(itemsOnTime) as an expression in the pivot table.

If it doesn't solve it , maybe you could share some data samples so the community can take a look

Regards,

Erich

topic Expression trouble in QlikView