Select only the null values of my dimension

[#1]

hello,

i have a table as below

NAME	ID	PRICE	ADRESS
name 1	123456	100	1 street a
name 2	234567	150	1 street f
-	456792	150	1 street d
name 3	654987	0	1 street v
-	321987	50	1 street b

I would like to have the following table

NAME	ID	PRICE	ADRESS
-	456792	150	1 street d
-	321987	50	1 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 

[daveamz]

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]

use the following in your script

NullAsValue NAME;

Set NullValue = '-'

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