Select "Missing" Values

firebohl — Tue, 06 Feb 2024 10:12:55 GMT

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.

Re: Select "Missing" Values

anat — Thu, 08 Feb 2024 02:39:52 GMT

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

Re: Select "Missing" Values

Nagaraju_KCS — Thu, 08 Feb 2024 03:42:03 GMT

Expression/Script level we can handle it

Like, LEN(Confirmation Number)>0

topic Re: Select "Missing" Values in QlikView

Select "Missing" Values

Re: Select "Missing" Values

Re: Select "Missing" Values