Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Select only the null values of my dimension

hello,

i have a table as below

NAMEIDPRICEADRESS
name 11234561001 street a
name 22345671501 street f
-4567921501 street d
name 365498701 street v
-321987501 street b

I would like to have the following table

NAMEIDPRICEADRESS
-4567921501 street d
-321987501 street b

I would like to create an expression to isolate the null in NAME in order to identify them in a table.

I was thinking first of using the Enable conditional field for the dimension but i never could manage it.

So then i tried to have it in a calculated expression (i transferred the feal NAME in an expression and tried to work it in there) but never made it too.

Any ideas?

Second question, what if i want to add another criteria related to another coloumn for instance like i would like to isolate the rows with NAME that is NULL     AND the row that has a price that is  0.

Thanks a lot 

2 Replies
daveamz01
Creator III
Creator III

Hi,

If you want to filter by NULL values, you have to mark them from the script like:

LOAD If(IsNull(NAME), 'Unknown', NAME) as NAME

....

Regards,

David

ali_hijazi
Partner
Partner

use the following in your script

NullAsValue NAME;

Set NullValue = '-'

THIS WAY YOU CAN SELECT THE NULL VALUES ON YOUR CHARTS OR LIST BOX

I can walk on water when it freezes