topic Re: Subtotalling Problem.... in QlikView

Subtotalling Problem....

Fri, 14 Sep 2012 10:31:46 GMT

Please see below.

My Raw data is listed by day, but I want to display the average for a 7 day period (obviously a week!) in my chart.

Im not sure which is the nbest way to tackle this as the raw data does not have a 'week' reference in it.

I would be very grateful for some pointers please!

Thanks

rajni_batra — Fri, 14 Sep 2012 10:39:02 GMT

use week function for this

week(Date )

or weekday(Date)

will return you week of respective Date

Hope to Help!!!

Fri, 14 Sep 2012 10:44:16 GMT

Thanks for your quick reply - Im new to Qlikview, could you explain a little bit more exactly where and how I use this function?

Thanks

Ian

rajni_batra — Fri, 14 Sep 2012 10:50:49 GMT

I tried this but confused that may be u wouldn't need it like this check it out n Let me Know

rajni_batra — Fri, 14 Sep 2012 10:53:02 GMT

Check this one also contains Avg (Amount) also..

Fri, 14 Sep 2012 13:54:04 GMT

Thanks for your reply, but I'm still struggling to understand....

How will qlikview understand where the week starts and finishes? Does it need some sort of lookup table to return a value from?

Thanks

Ian

Fri, 14 Sep 2012 14:04:58 GMT

So how does it know which days make the week? (Sat to Friday or Monday to sunday etc)?

Thanks

ian

jonathandienst — Fri, 14 Sep 2012 14:11:44 GMT

In your load statement, add the week like this

LOAD Day,

Amount,

Week(Day) As WeekNo,

...

FROM ...

Now create a chart wih WeekNo as the dimension, and Sum(Amount) as the expression.

Hope that helps

Jonathan