Ignore nulls from year?

[#1]

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

[kaushiknsolanki]

Hi,

    Here is your answer.

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

Regards,

Kaushik Solanki

[#3]

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

[kaushiknsolanki · Accepted solution]

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

[#5]

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