show null as value

[#1]

Hi guys,

can you tell me it is possible to show null als 0?

I have years, months and amount. with there dim like customer and region. ->sum(amount)

My intention is to create a chart with the rolling months or Years+Months - for showing the trend of  a Dim..

for example: Trend from Customer X fron year 2012 - 2014.

The problem here is, if I uncheck surpress null and check: show all values- it shows every year/month// rollingmonth that is in my database..

the only way that I achieved is a chart with 1DIM (Months)-> there it shows the 0 as

But I need to show the trend over years in months.

How can I realize that ? and Where: in Scripting or BackEnd in Expressions..?

I would like to achieve this but with all months, not only where is an amount..

like this

but with the 0 in the years.. not seperated

[jyothish8807]

Hi,

Try in your script

if((isnull(trim(Amount)=-1,0,Amount) as Amount

Regards

KC

[jyothish8807]

sorry,try this.

if(isnull(trim(Amount))=-1,0,Amount) as Amount

Regards

KC

[ashfaq_haseeb]

Hi,

go throught this article

http://community.qlik.com/docs/DOC-3155

Regards

ASHFAQ

[#5]

it doesnt change anything 😕