Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
I have put it at the start of script i.e. on the Main tab but still doesn't work?