topic Ignore nulls from year? in QlikView

Ignore nulls from year?

Mon, 11 Jul 2011 09:53:17 GMT

A general query,

I have the code as seen here at script level, which after reloaded gets the year dimension with blanks. I want to get rid of this and not see the blanks at all.

if(year >= '2006' and year <= year(today()), year,'') as year_dim,

Any help is appreciated.

Mady

Ignore nulls from year?

kaushiknsolanki — Mon, 11 Jul 2011 09:58:19 GMT

Hi,

Here is your answer.

http://community.qlik.com/message/131647#131647

Regards,

Kaushik Solanki

Ignore nulls from year?

Mon, 11 Jul 2011 10:01:42 GMT

Hello Kaushik,

Thanks for the quick reply, but I have this at the load script level and I dont want to ignore all null values(but only from year dimension), I am aware that we can ignore nulls, when we use this dimension within charts. I have year as a list box selector and it shows blanks which I dont want. Is there any other way to do it?

Thanks Again,

Mady

Ignore nulls from year?

kaushiknsolanki — Mon, 11 Jul 2011 10:03:51 GMT

Hi,

Then change your expression to

if(year >= '2006' and year <= year(today()), year) as year_dim,

If you notice i have removed the '' from the expression, so now you will not get any null values.

Regards,

Kaushik Solanki

Ignore nulls from year?

Mon, 11 Jul 2011 10:06:42 GMT

Thats what i was looking exactly for. But the strange thing was first I tried the below and it gave an error, that IF should have 2 parameters.... I wasnt sure why it did get me that error message??

if(year >= '2006' , year) as year_dim,

Anyways thanks for your time.

Mady