topic How to compare & analyse the data for three months in QlikView

How to compare & analyse the data for three months

Mon, 04 Oct 2010 11:15:54 GMT

Hi ,

I need to compare the data for the selected month with previous 2 months.

I am using the sample done by John.

If i select jan 2010 i should see the same data as of the Year, but only for the 3 months(I will post you the exact result in the next post).

But the data i am getting is the avarage of three months.

Please find attached and let me know if this is acheivable in this way or there is any other approach.

Thanks,

Srihari.

Mon, 04 Oct 2010 11:21:17 GMT

This is what is exactly needed on selecting jan 2010.

renjithpl — Mon, 04 Oct 2010 11:30:58 GMT

kindly look at the attachment, is it something like that.. using trellis..

Mon, 04 Oct 2010 11:45:40 GMT

From the report attached, initially the productive hours for Jan,Feb,Mar is showing 57,58,59 %.

If you select jan 2010 , then you are getting the avarage . The productive hours are showing as 57 % for jan,feb and mar.

I need to get the actual data ,not the avarage.

Please suggest

qliksus — Mon, 04 Oct 2010 12:14:36 GMT

Hi buddy,

i have done some modification in the file and attached .I have created a new table called Main1 and created 2 variables

called a and b and used that in the expression also in the list box i have created a small expression .Please find your attached file

for reference .If this is not what you are looking for then let me know

qliksus — Mon, 04 Oct 2010 12:21:01 GMT

Sorry i forget to add the this expression "

sum

({<Date11={">=$(a)<$(b)"}>}ProductiveHours)/sum({<Date11={">=$(a)<$(b)"}>}TotalHours) "

please add this and check

qliksus — Mon, 04 Oct 2010 13:06:47 GMT

If you want to achieve the result with your logic use the following expression "

aggr

(sum({<MonthYear=>}ProductiveHours)/sum({<MonthYear=>}TotalHours),RollingThreeMonthsAsOfMonthYear) "

Mon, 04 Oct 2010 13:31:14 GMT

Hi,

Thanks a ton for providing these many options

Is there anything wrong with the syntax of the query below :

aggr(sum({<MonthYear=,[ProductiveType]={'non productive'}>}[TotalHours])/sum({<MonthYear=>}TotalHours),RollingThreeMonthsAsOfMonthYear)

Thanks,

Srihari