topic Re: show null as value in QlikView

show null as value

Tue, 23 Sep 2014 08:27:36 GMT

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 — Tue, 23 Sep 2014 08:36:24 GMT

Hi,

Try in your script

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

Regards

jyothish8807 — Tue, 23 Sep 2014 08:37:22 GMT

sorry,try this.

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

Regards

ashfaq_haseeb — Tue, 23 Sep 2014 08:39:41 GMT

Hi,

go throught this article

Regards

ASHFAQ

Tue, 23 Sep 2014 09:04:06 GMT

it doesnt change anything 😕