Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

kumarreddy257
Contributor

Roll up data week wise

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

1 Solution

Accepted Solutions

Re: Roll up data week wise

Is this not what you wanted?

Capture.PNG

7 Replies

Re: Roll up data week wise

What is your desired results?

kumarreddy257
Contributor

Re: Roll up data week wise

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

Try this may be:

Calculated Dimension: WeekStart(Date)

Expression: Sum(Measure)

kumarreddy257
Contributor

Re: Roll up data week wise

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

Regards,

Kumar

Re: Roll up data week wise

Is this not what you wanted?

Capture.PNG

kumarreddy257
Contributor

Re: Roll up data week wise

My apologize and it is working. Thanks a lot.

Re: Roll up data week wise

No worries...

I am glad it worked.

Best,

Sunny

Community Browser