Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
summerrain
New Contributor III

Dealing with null values inside table box/pivot table

Hi Community,

I have a table box representing data:

IDStatus
1-
2Paid
3Waiting
4Canceled
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:

IDStatus
1-
5-

IDStatus
2Paid
3Waiting
4Canceled

Is that possible to achieve?

Thank you!

1 Solution

Accepted Solutions

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

Have a look at the attachment.

Untitled.png

2 Replies

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

Have a look at the attachment.

Untitled.png

karthikoffi27se
Contributor III

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

Hi


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