browse and select the data

[#1]

Hi, (sorry for my basic english)

I have this type of data, the red line :

And i want to predict the following, the blue line.

(here it's just the average of each hours)

I have no idea how to do that, someone can help me please ?

Regards,

[datanibbler]

Hi Jourdan,

we had something like that once - in fact, that was the very first app that I created in this company (with the help of an external consultant). I don't have it anymore, but I will tell you the steps as best I remember (in my instance, the figure was a (cumulative) sum of damage_events and the associated financial amount, so I will refer that)

- I used the fields from my master_calendar as dimension, but that will only work for you if that runs up to some future

   date. Otherwise you'll have to create another one or edit it accordingly.

- First I calculated what was the damage_amount that we had on average per day (in the entire selected time_window

   up until the present day)

- I used an IF_construct to distinguish:

     - Up until the present day, I would still depict whatever was calculated  by QlikView

     - Starting from the present day, I would depict the real data, every day adding the calculated average.

HTH

Sorry I don't have that particular graph anymore, so I cannot tell you more exactly how it was made. That, like everything I've done so far, was terribly important and pressing for a short time - and then faded into oblivion again ...

[buzzy996]

seems they simply applied some color code based on ur dimension.

for example,if ur dimension is date...if so..if(month(date)={'jan','feb','mar'},rgb(pass here values for red color),rgb(pass here values for blue color)) --this expression u suppose to write on Background color of ur expression.

[#4]

I think that's approximately what i've done :

- i used a calendar with past date and future

but not with if, with two expression :

red : my sum

avg(

     aggr(

          sum(value)

     ,dtime)

)

then in blue, for each hour the average of TOTAL hour

if(isnull(

     aggr(

          Count(avg_value)

     ,dtime)

     )

     ,

     if(dtime like '* 00:00'

          ,

          avg(TOTAL

               aggr(

                    sum({<dtime = {'* 00:00'}>}avg_value)

               ,dtime)

          )

          ,

          if( dtime like '* 01:00'

               ,

               avg(TOTAL

                    aggr(

                         sum({<dtime = {'* 01:00'}>}avg_value)

                    ,dtime)

               )....