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.
