topic Adress empty fields in set analysis in QlikView

Adress empty fields in set analysis

Mon, 20 Apr 2015 13:42:00 GMT

Hi all,

I have the attached table.

Now I have a text object with the next set analysis expression:

sum({<OPCODE_COUNT.OPCODE={'CANDIDATE'},OPCODE_COUNT.MA={''}>} SUBSCRIBER_COUNT)

I keep getting 0.

though the result should be 1 because I'm referring only to the last 3 rows in the table from a previous selection.

Any Idea how to address this empty fields?

ali_hijazi — Mon, 20 Apr 2015 14:23:54 GMT

these are null values not empty strings

you can the following to be able to refer to these null values

in your script add the following:

NULLASVALUE your_field;

SET NULLVALUE = 'OTHER';

...

YOUR LOAD SCRIPT GOES HERE

then you can refer to these in set analysis OPCODE_COUNT.MA={'OTHER'}

Tue, 21 Apr 2015 07:06:07 GMT

Thanks, in the end I used the isnull() in the load script and gave it a value.