topic Week aggregation in QlikView

Week aggregation

Fri, 07 Oct 2011 06:10:25 GMT

Hey Guys,

i have an additional problem:

I want to aggregate the data per day to data per week at the user surface, NOT in the Script.

For example:

Initiatl Situation:

raw data imported via sql-script:

01.01. 10

02.01 20

03.01 30

04.01 45

05.01 45

06.01. 50

07.01. 60

...

(e.g. 01.01. = Monday, 01.01. - 07.01. -> Week 1)

Favored Solution:

Output in a table-box:

CW 01 260

...

Is there a possibility to solve this problem in the chart properties via a definition?

Someone who has an idea?

Many thanks in advance!

kaushiknsolanki — Fri, 07 Oct 2011 07:40:36 GMT

Hi,

Only one change you need to do inscript, i.e Create a new field week from the date you have.

This will give you the week number for the given date.

You can create a new field as shown below.

Load

Date,

week(Date) as Week,

.......

From xyz.

Now you can use this week field in your chart to aggrigate the values.

Create a chart with dimension as Week and expression as Sum(Values).

Hope this helps.

Regards,

Kaushik Solanki

Anonymous — Fri, 07 Oct 2011 12:58:22 GMT

Or, if you don't have access to the script, you can use calcualted dimension (not chart expression), defined like this:

=week(Date)

Expression will be the same sum(Values)