topic Dealing with null values inside table box/pivot table in QlikView

Dealing with null values inside table box/pivot table

summerrain — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I have a table box representing data:

ID	Status
1	-
2	Paid
3	Waiting
4	Canceled
5	-

What I want to achieve is to represent data in two table box(or couldbe pivot tables, it doesn't really matter), where one would be only with null(empty) values in the field Status and another without nulls:

ID	Status
1	-
5	-

ID	Status
2	Paid
3	Waiting
4	Canceled

Is that possible to achieve?

Thank you!

Re: Dealing with null values inside table box/pivot table

tamilarasu — Mon, 27 Jun 2016 15:56:59 GMT

Have a look at the attachment.

Re: Dealing with null values inside table box/pivot table

karthikoffi27se — Mon, 27 Jun 2016 19:37:50 GMT

You can use the below syntax in the script and call it in expression using set analysis.

NullAsValue*;

Set NullValue = '<NULL>';

Hope this helps

Many Thanks

Karthik