topic Re: why does charts show zero values seperated? in QlikView

why does charts show zero values seperated?

Mon, 22 Sep 2014 09:09:52 GMT

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

Re: why does charts show zero values seperated?

sathishkumar_go — Mon, 22 Sep 2014 11:26:42 GMT

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?

avinashelite — Mon, 22 Sep 2014 11:28:59 GMT

Hi Tobias,

This is because of null values in the chart.

In the Dimension Check >Suppress null values option

Re: why does charts show zero values seperated?

Mon, 22 Sep 2014 11:58:59 GMT

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.

Re: why does charts show zero values seperated?

Mon, 22 Sep 2014 12:00:07 GMT

there is no other in my expression.

I have only sum(amount) in my expression

Re: why does charts show zero values seperated?

sathishkumar_go — Mon, 22 Sep 2014 12:05:55 GMT

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

-Sathish

Re: why does charts show zero values seperated?

Mon, 22 Sep 2014 12:12:47 GMT

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 ..

Re: why does charts show zero values seperated?

sathishkumar_go — Mon, 22 Sep 2014 12:23:27 GMT

Try this

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

-Sathish

Re: why does charts show zero values seperated?

sathishkumar_go — Mon, 22 Sep 2014 12:24:57 GMT

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

Re: why does charts show zero values seperated?

demoustier — Mon, 22 Sep 2014 12:26:09 GMT

hi,

Do you try 'NullAsValue' function ?

krgds

Re: why does charts show zero values seperated?

Mon, 22 Sep 2014 12:29:34 GMT

No no,

I want like this

But, the zeros should be in 2014.. not separeted..

Re: why does charts show zero values seperated?

Mon, 22 Sep 2014 12:31:42 GMT

It doenst work..

i also tried

if(Month(IsNull(sum(EURamount))),0.1,sum(EURamount))

Re: why does charts show zero values seperated?

sathishkumar_go — Mon, 22 Sep 2014 12:35:44 GMT

ok.. then you have to work on data modelling itself.

you have to create "0" in month field and it has to be mapped with norelated datas.

If you are not understanding please attach the application here

-Sathish

Re: why does charts show zero values seperated?

Mon, 22 Sep 2014 12:39:11 GMT

right, but how can I express this in my script?

I have also other Types like Region, Customer, Salesperson ...

How can I tell Qlikview to show 0 for every Dimension if its not a value ?

Re: why does charts show zero values seperated?

demoustier — Mon, 22 Sep 2014 12:39:53 GMT

Did you tried :

In your graphic Propriety box, sheet Dimension, stick ‘Shows Al value”

Re: why does charts show zero values seperated?

Mon, 22 Sep 2014 12:51:55 GMT

yes, but it shows chart in separated years: "2014" and "-"

Re: why does charts show zero values seperated?

demoustier — Mon, 22 Sep 2014 12:59:12 GMT

is it possible to post your .qvw ?

Re: why does charts show zero values seperated?

sathishkumar_go — Mon, 22 Sep 2014 13:10:51 GMT

Its very easy only.. attach your application or attach your data modelling.

-Sathish