topic nervous chart in QlikView

nervous chart

francis_gr — Thu, 23 Sep 2010 12:51:27 GMT

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

nervous chart

deepakk — Thu, 23 Sep 2010 13:05:36 GMT

Can you attach a sample application.

nervous chart

francis_gr — Thu, 23 Sep 2010 19:03:10 GMT

Hi Deepak!

Check this one

Regards

nervous chart

Thu, 23 Sep 2010 19:12:14 GMT

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.

nervous chart

francis_gr — Fri, 24 Sep 2010 19:00:35 GMT

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.

nervous chart

Fri, 24 Sep 2010 19:47:48 GMT

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,

...

nervous chart

francis_gr — Sat, 25 Sep 2010 21:46:52 GMT

Thanks Eduardo!!

I have followed your indications and solves the problem perfectly.

Regards