nervous chart

[francis_gr]

Hi!!

I have done a bar chart with 2 dimensions and 1 expression.

Dimension1

If(Date(MakeDate(Año,mes),'MM/YYYY')>=Ini_Hco and Date(MakeDate(Año,mes),'MM/YYYY')<=Date(MakeDate(Year(FechaInforme),Month(FechaInforme)),'MM/YYYY'),MESAÑO)

Dimension 2

Centro_Dep (it`s a field in a access table)

Expression

Sum ( If ( Not IsNull ( Centro_Dep ), 1 , 0 ))

The chart shows for each month and year, how many people is in each departament

Inexplicably, for a few seconds (maybe 1 or 2) and randomly, the chat bars disappear and appear, justl like the chart recalculate itself

Is there somebody with something similar??

how I can be solved?

Thanks

[deepakk]

hi

Can you attach a sample application.

[francis_gr]

Hi Deepak!

Check this one

Regards

[#4]

Hi,

change the expression

Sum ( If ( IsNull(Centro_Dep) = 0, 1 , 0 ))

The funciton ISNULL return -1 if the values = NULL and 0 if the value is not null.

[francis_gr]

Hi Eduardo!

I have changed the expression but the chart keep doing the same!!

I think the problem is the dimension

=If(Date(MakeDate(Año,mes),'MM/YYYY')>=Ini_Hco and Date(MakeDate(Año,mes),'MM/YYYY')<=Date(MakeDate(Year(FechaInforme),Month(FechaInforme)),'MM/YYYY'),MESAÑO)

Is there any way to simplify the expression??

thanks.

[#6 · Accepted solution]

Hi,

Your variable "FechaInforme" is using a function "NOW()".

This this function use the system datetime and update every second.

Try declare a fild whith this function, and dont use into a variable.

Ex.:

LOAD

...

NOW() AS FechaInforme,

...

[francis_gr]

Thanks Eduardo!!

I have followed your indications and solves the problem perfectly.

Regards