Not capturing data for all months

[#1]

Hi All,

I have some monthly data from 2011 up until Feb 2012...and for some reason my graphs are only giving me values up until Jan-2012. I have just created these graphs and have not made any such restriction....at least not that I know of. Any ideas why my graphs are not picking up all the relevant data? Should mention this is only applicable to one of my tabs...all the other tabs with graphs work fine.

Thanks in advance and Krgds,

Lennart

[CELAMBARASAN]

Hi,

     Did you checked whether expression return value for that month?

     If it is zero try by un check the suppress zero value option in the presentation tab of chart properties.

Celambarasan

[#3]

Hi Celambarasan,

Thanks for the reply but I have values for Feb-2012 in my excel file so they should be showing. And surpressing zero values doesn’t help.

Krgds,

Lennart

[CELAMBARASAN]

Hi,

     Can you tel me your expression and where you applied it(Chart type)?Dimensions?

Celambarasan

[#5]

Hi,

Expression is very simple. The chart is a combo chart (column & line) with Actual and Target values.

Expression for the Actual numbers: Sum(ActEscapes)

Expression for the Target numbers: Sum(TargetEscapes)

Krgds,

Lennart

[CELAMBARASAN]

Hi,

     Which qlikview version are you using?

Celambarasan

[#7]

Hi,

It’s the free downloadable version that I downloaded beginning of Feb.

Version 11.00.11154.0 IR

Krgds,

Lennart

[CELAMBARASAN]

Hi,

     Have you checked whether you have used Restrict option in the dimension limits tab of the chart properties?

Celambarasan

[#9]

Hi,

Yepp, was one of the first things I checked actually….no restrictions applied whatsoever.

/L

[jagan]

Hi,

Can you attach the sample file.

Regards,

Jagan.