topic Re: Roll up data week wise in QlikView

Roll up data week wise

Anonymous — Thu, 30 Jul 2015 13:52:27 GMT

Hello experts,

I have year data and my requirement is it should roll up data week wise.

For example.

week measure

7/30/2015 20

7/23/2015 50

7/16/2015 40

7/09/2015 100

The data here splitting week wise and rolling up, what are the data available in that weeks.

Please help me on that issue.

Regards,

Kumar

Re: Roll up data week wise

robert_mika — Thu, 30 Jul 2015 13:58:55 GMT

What is your desired results?

Re: Roll up data week wise

Anonymous — Thu, 30 Jul 2015 14:21:44 GMT

Hi,

Pls find the screen shot of requirement.

In this screen shot for every week it is rolling up .

measures for each respectively

1) =count(DISTINCT{$<[Site Visit Hit Source]={"<>5,7,8,9"}, [Site Visit Post Page Event] = {0}>} [Visitor ID])

2) =count(DISTINCT{$<[Site Visit Hit Source]={"<>5,7,8,9"}, [Site Visit Post Page Event] = {0}>} [Visitor ID]&'_'&[Site Visit Vis Num])

3) =sum({$<[Site Visit Hit Source]={"<>5,8,9"}, [Site Visit Post Page Event] = {0}>} [Site Visit Record Count])

like that I can calculate.

But in the dates I want to roll up for each week.

Re: Roll up data week wise

sunny_talwar — Thu, 30 Jul 2015 15:50:40 GMT

Try this may be:

Calculated Dimension: WeekStart(Date)

Expression: Sum(Measure)

Re: Roll up data week wise

Anonymous — Fri, 31 Jul 2015 09:18:06 GMT

Thanks for ur reply. It is splitting by week wise, but roll up is not happening.

Regards,

Kumar

Re: Roll up data week wise

sunny_talwar — Fri, 31 Jul 2015 11:08:16 GMT

Is this not what you wanted?

Re: Roll up data week wise

Anonymous — Fri, 31 Jul 2015 11:27:43 GMT

My apologize and it is working. Thanks a lot.

Re: Roll up data week wise

sunny_talwar — Fri, 31 Jul 2015 11:28:59 GMT

No worries...

I am glad it worked.

Best,

Sunny