topic Re: Abnormality with Month Field on Chart in QlikView

Abnormality with Month Field on Chart

Thu, 13 Aug 2015 09:19:16 GMT

Hello Everyone,

as you can see on the picture I have attached, my bar chart represents the number of Cartons according to the months.

However, on the right of the chart you can see that one Month field is called '-' which is weird as I am certain that 100 % of my entries have a date assigned ( and as a consequence a month).

Do you know what could be the cause of that ?
Cheers, I wish you all a nice day
Alex

Re: Abnormality with Month Field on Chart

sunny_talwar — Thu, 13 Aug 2015 09:22:31 GMT

May be convert your chart in a straight table and add some more dimensions to see what is going on. One issue can be that the information for this chart is coming from different table in QlikView and the join is causing you to see Null(). With just looking at the image this is the best I can think of.

HTH

Best,

Sunny

Re: Abnormality with Month Field on Chart

Thu, 13 Aug 2015 09:23:28 GMT

That '-

' belongs to null values in your data,

check the option suppress null value in dimensions tab

Re: Abnormality with Month Field on Chart

MK_QSL — Thu, 13 Aug 2015 09:25:14 GMT

Provide sample data or sample application... These are null values !

Re: Abnormality with Month Field on Chart

robert_mika — Thu, 13 Aug 2015 09:25:22 GMT

Do you have any null values in you expression field?

Check:

NULL handling in QlikView

Feeling Qlikngry?

How To /Missing Manual(18 articles)

Re: Abnormality with Month Field on Chart

kuczynska — Thu, 13 Aug 2015 09:32:36 GMT

If you are sure that all of the month entries are populated but you still see null values in your chart, you basically have two options:

- you can either ignore it and supress the null values

- you want to dig deeper and find out what's going on. As advised by Sunny - display all of you related dimension in the straight table and have a look. If you don't have null values in your data set, there is one more option - there is a chance you can create them yourself. Are you using join or concatenate in your load script? Are you using any ApplyMap() functions on your table and do not have the [ , defaultexpr ] populated? In that case QV will fill them with nulls.

applymap('mapname', expr [ , defaultexpr ] )

Similar with IF statement - did you define else part in each statement? If not - it might be populated with null.

It's worth checking. Good luck!