topic Re: How complete empty values of a certain table? in QlikView

How complete empty values of a certain table?

benoittanga — Wed, 25 Nov 2020 16:16:04 GMT

Hi all ,

I have a question regarding "Null" values of one my table in QV. I'll try to explain as better as I can:

- My QV is charging a lot tables, and most of them contain empty values
- the main role of my app is to calculate KPI (completeness, accuracy) and so I have configure the NullInterpret in the beginning of my script, with these statements :

// AUTOMATIC CONVERT OF NULL INTO 'VIDE'
MissingTextMap:
MAPPING LOAD
null(), 'VIDE' AutoGenerate 1;

// AUTOMATIC CONVERT OF NULL INTO 'VIDE' WORD + ZERO NUMBER
MissingNumberMap:
MAPPING LOAD
null(), Dual('VIDE',0) AutoGenerate 1;

// HIDE PREFIX
Set hideprefix = '_';
set NullInterpret='';

My problem is: one of my table is storing results of a calculation, with the value "OK" (when the calculation is correct, obvously). I need to fill the others values by the word "NOK" but I don't know how to do it.

Theses "Null" Values are not filled with the word "VIDE" (as the others table) and so I don't really understand what is going on

Waiting for your feedback, and thanks for having read me

Ben

Re: How complete empty values of a certain table?

pradosh_thakur — Fri, 15 Feb 2019 11:07:39 GMT

Let's say that column which contain OK is "Flag"

You do the Following in the script

if(len(trim(Flag))=0,'NOK',Flag) as Flag

Re: How complete empty values of a certain table?

benoittanga — Fri, 15 Feb 2019 15:50:24 GMT

Hi,

Okay, I'll try this! Thank you very much 🙂

Re: How complete empty values of a certain table?

rwunderlich — Fri, 15 Feb 2019 17:06:13 GMT

You don't show your MAP USING statement, that would be required. Also, if your null values are created indirectly by a join, you may have to pass through the table again to map. See https://qlikviewcookbook.com/2013/01/filling-default-values-using-mapping/

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com