topic Re: Flag a null value in QlikView

Flag a null value

renjithpl — Mon, 19 Jun 2017 13:52:20 GMT

Hi all,

Is it possible to flag as "Null", if in a formula where the numerator or denominator has null value in a straight table. ?

Regards

Renjith

vishsaggi — Mon, 19 Jun 2017 14:02:30 GMT

Can you elaborate?

May be like this?

LOAD Numerator,

Denominator,

.....,

IF(ISNULL(Numerator) = -1, 1, 0) AS NumeratorFlag,

IF(ISNULL(Denominator) = -1, 1, 0) AS DenominatorFlag

From Source;

felipedl — Mon, 19 Jun 2017 14:03:34 GMT

Hi Renjith,

You could do something like that in the modeling or by expression.

With the flag you can select the ones that have zero or null values.

Felipe.

avinashelite — Mon, 19 Jun 2017 14:20:17 GMT

Try like this

if(len(trim(expression))=0,1,0)