Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

show null as value

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

Tags (3)
4 Replies
jyothish8807
Honored Contributor II

Re: show null as value

Hi,

Try in your script

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

Regards

KC

Best Regards,
KC
jyothish8807
Honored Contributor II

Re: show null as value

sorry,try this.

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

Regards

KC

Best Regards,
KC

Re: show null as value

Hi,

go throught this article

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

Regards

ASHFAQ

Not applicable

Re: show null as value

it doesnt change anything :/

Community Browser