Select only the null values of my dimension

Thu, 13 Nov 2014 15:35:07 GMT

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

Re: Select only the null values of my dimension

daveamz — Thu, 13 Nov 2014 15:56:08 GMT

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

Re: Select only the null values of my dimension

ali_hijazi — Thu, 13 Nov 2014 15:59:33 GMT

use the following in your script

NullAsValue NAME;

Set NullValue = '-'

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

topic Re: Select only the null values of my dimension in QlikView

Select only the null values of my dimension

Re: Select only the null values of my dimension

Re: Select only the null values of my dimension