topic Re: Bar chart in QlikView

Bar chart

Fri, 05 Jun 2015 06:32:37 GMT

Hi All,

I am having following data.Based on the data I developed one bar chart ,But it shows Dec,Oct data .But not showing Nov data.But i want to display Nov count as 0.

Here

1.Dimension is Month.

2.Expression is Count(Value)

Month,Value

Dec,10

Nov,

Oct,20

Dec,30

Nov,

Oct,40

Re: Bar chart

Siva_Sankar — Fri, 05 Jun 2015 06:39:41 GMT

uncheck 'Suppress Zero Values' under presetation tab of chart properties. find the attachment.

Re: Bar chart

PradeepReddy — Fri, 05 Jun 2015 06:40:55 GMT

Unchecked the bellow options in Presentation tab and try

1) Suppress Zero Values

2) Suppress Missing

Re: Bar chart

qlikmsg4u — Fri, 05 Jun 2015 06:44:40 GMT

Properties > Presentation

1. Uncheck Supree Zero Values

2. Tick Zero on Values

Properties > Expression

1. Tick value on Data Points.

Re: Bar chart

MarcoWedel — Fri, 05 Jun 2015 22:41:14 GMT

Hi,

one solution to show even months without values could be:

tabData:
LOAD RecNo() as ID,
    Month(Date#(Month,'MMM')) as Month,
    If(Len(Value),Value) as Value
INLINE [
    Month, Value
    Dec, 10
    Nov
    Oct, 20
    Dec, 30
    Nov
    Oct, 40   
];

tabMonths:
LOAD Month(Date#(RecNo(),'M')) as Month
AutoGenerate 12;

Loading the months like this avoids sorting issues like in your screenshot.

hope this helps

regards

Marco

Re: Bar chart

Sat, 06 Jun 2015 08:20:01 GMT

Hi ,

you can try this.