topic Re: browse and select the data in QlikView

browse and select the data

Tue, 30 Jun 2015 13:42:56 GMT

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,

Re: browse and select the data

datanibbler — Tue, 30 Jun 2015 13:52:44 GMT

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 ...

Re: browse and select the data

buzzy996 — Tue, 30 Jun 2015 14:00:25 GMT

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.

Re: browse and select the data

Tue, 30 Jun 2015 15:00:50 GMT

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)

)....