Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted

Is this not what you wanted?

Capture.PNG

View solution in original post

7 Replies
Highlighted

What is your desired results?

Highlighted
Creator
Creator

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.

Highlighted

Try this may be:

Calculated Dimension: WeekStart(Date)

Expression: Sum(Measure)

Highlighted
Creator
Creator

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

Regards,

Kumar

Highlighted

Is this not what you wanted?

Capture.PNG

View solution in original post

Highlighted
Creator
Creator

My apologize and it is working. Thanks a lot.

Highlighted

No worries...

I am glad it worked.

Best,

Sunny