topic Comparison acumulatte in QlikView

Comparison acumulatte

Sat, 26 Mar 2011 04:25:31 GMT

Good evening,

I have a table with the number of open call day.

My boss wants data to be accumulated prior to, or perhaps 12 days 365 days earlier to remove the seasonality of the year.

And my boss wants a light indicating: If today was lower than yesterday: ok (green), if today is the same as yesterday: warning (yellow), today is greater than yesterday: poor (red)

And every day he'll open up that QOL, reload the data to see the comparison.

Any tips?

Thanks a lot

Gledson

Re. :Comparison acumulatte

Sat, 26 Mar 2011 11:29:47 GMT

Hello,

Can you try to add these lines in your script and use the fields in you graphs.

Hope that help

Philippe

temp:

load

DataOco

sum

(NumOco) as

SumNumOco

resident

OcorrênciaSérieHistórica

group

DataOco

order

by DataOco

;

LastDayTable:

load

DataOco

SumNumOco

as SumNumOco

(DataOco<>previous(DataOco),previous(SumNumOco)) as

LastSumNumOco

resident

temp2;

drop

table

temp2;