Data with 'NULL' values not visible

[marcvw]

Good Day, 

I have a table with raw data that contains 'NULL' values and a value like '5', '10'. See enclosed file. 

How can I enable that Qlik sense will demonstrate all values in a table? 

Appreciate your support in here. 

Regards, 

[BrunPierre · Accepted solution]

To display duplicates, you must create a unique row identifier with either of these RowNo() or Recno().

Something like this;

LOAD RowNo() as R#,
id,
Coalesce(value,'Null') as value
FROM ...