Left join and isnull

[denwo2010]

Hi, I have the following script LEFT JOIN  LOAD If(IsNull([PO Total])=-1,0,[PO Total]) as [PO Total],     [Order No]&'_'&[Order Line No] as [PO Key]     FROM D:\QlikView\02_QVD\po_shipping_aggr.qvd (qvd); DROP FIELDS [PO Key]; When I have the results back for the PO Total, the ones where there is no match it will show as '-' ? I want it to appear as 0 as I would expected from the abive If Isnull logic? Any ideas how to get round this? Thanks

[kaushiknsolanki]

Hi,

     No I said put it before your load Statement, you can out in main table below the variables.

     Not within the load statement.

Regards,

Kaushik Solanki

[denwo2010]

I have put it at the start of script i.e. on the Main tab but still doesn't work?