Bar chart

[#1]

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

[Siva_Sankar]

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

[PradeepReddy]

Unchecked the bellow options in Presentation tab and try

1) Suppress Zero Values

2) Suppress Missing

[qlikmsg4u]

Properties > Presentation

1. Uncheck Supree Zero Values

2. Tick Zero on Values

Properties > Expression

1. Tick value on Data Points.

[MarcoWedel]

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

[#6]

Hi ,

you can try this.