Total Averages in Table - Data Clean for Zero and Strings

[#1]

Dear All,

I have read something about how Qlik is handling null(). My Excel sheet I am loading from has records containing 0 or "-".

So I would like to clean my data and replace all these records with a null() in the load script.

Additionally, what I am looking for is to load the data in a table and averaging the results. However, I do not get the right averages, even though I have made an atempt to clean data in the first place.

I have attached an example, imagine the first load is the excel load.

[#2]

Similar to the Inload 😉

[#3 · Accepted solution]

Ok, I finally got the result:

Set NullInterpret = '-';   

mapNull:
MAPPING LOAD 0 as Key, null() as Value
Autogenerate(1);

MAP * USING mapNull;