Select "Missing" Values

[firebohl]

Hello,

I got two Tables in QlikView:

Purchase Orders with Columns:

Purchase Order Number; Purchase Quantity
6000; 100
6001; 200
6002; 50

PO Confirmations with Columns:
Purchase Order Number; Confirmation Number; Confirmed Quantity
6000; 1000; 50
6002; 1001; 50

From this I (and QlikView) create a Report Table like this:

Purchase Order Number; Purchase Quantity; Confirmation Number; Confirmed Quantity; Sum Open Quantity
6000; 100; 1000; 50; 50
6001; 200; -; -; 200
6002; 50; 1001; 50; 0

Is there a possibility with this Table Structure to select in column "Confirmation Number" only results where no entry in PO Confirmations is available? The second line with "-" only? Because in my Dropdown List I can see only 1000 and 1001.

[anat]

Can you apply null handling techniques in script level... Like pass default value as NA or 0 if value is null or blank 

[Nagaraju_KCS]

Expression/Script level we can handle it 

Like, LEN(Confirmation Number)>0