Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I load 2 CSV files and I get many values of "-" (see image), which I guess means NULL (and that's fine). The reason, I guess, is because of missing values, which is also fine, because I want to see those missing values.
THE PROBLEM is that I cannot filter only on those missing values, so I want to replace the missing values with a string like i.e. 'NULL'
How can I do that? Here's what I tried (Qlik Sense version 3.2):
NullAsValue *;
Set NullValue = 'NULL';
// set NullInterpret='';
// SET NULLDISPLAY='NULL';
LOAD
"s-p-n",
title as m_title
FROM [lib://Other/mss-m.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);
LOAD
"s-p-n",
"p-p-nr" as [s_p-p-n],
e as s_e,
title as s_title
FROM [lib://Other/mss-q.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);
Hi Adli,
I´m no expert, but one more guess would be to load the field like:
if ( isNull(<field>),'empty', <field>) as field.
Just a wild guess though, good luck ^^
Cheers,
Yve