Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

why does charts show zero values seperated?

hi guys, I hope you can help me

I have 3DIM: 1. Country, 2.FMonth, 3.FYear.

I want to show all Values from FMonth (checked, and also supress zero)

Now it shows the values in separated Years with selected and with "-" where the NULL values are..

Is it possible to combine the NULL/Zero-Values in 1 Year ?

I have also tested with "show all values " for Fyear(3. DIM), but it only shows every year that I've got in my Database..

Best regards,

Tob

Tags (4)
17 Replies
sathishkumar_go
Contributor III

Re: why does charts show zero values seperated?

Hi Tob,

In your chart "-" is coming because you have some data (used in expression fields) but month is not abilable for those datas.

You have to check your data modelling.

-Sathish


Re: why does charts show zero values seperated?

Hi Tobias,

This is because of null values in the chart.

In the Dimension Check >Suppress null values option

Not applicable

Re: why does charts show zero values seperated?

if I supress this, it only shows the month were are an amount,

my intention is to show the trend with all months, even if there is not an amount.

Not applicable

Re: why does charts show zero values seperated?

there is no other in my expression.

I have only sum(amount) in my expression

sathishkumar_go
Contributor III

Re: why does charts show zero values seperated?

Issue is some Amount data don't have month. you have to check ur data or data modelling (Linking fields)

-Sathish

Not applicable

Re: why does charts show zero values seperated?

yea, right, because some months don't have amount, but how can I express, to show that NULL as zero or something like that..

my intention is, to show the NULL or the months, where isnt an amount like Okt, Nov, Dez,...

or just simple here

but in FMonths isnt an amount, so it supress that ..

sathishkumar_go
Contributor III

Re: why does charts show zero values seperated?

Try this

     In dimension if(isnull(Dimension field),'Not Mapped',Dimension Field)

-Sathish

sathishkumar_go
Contributor III

Re: why does charts show zero values seperated?


you want to show "0" instead of 14,167?

demoustier
Contributor

Re: why does charts show zero values seperated?

hi,

Do you try 'NullAsValue' function ?

krgds

Community Browser