Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
sunny_talwar

Is this not what you wanted?

Capture.PNG

View solution in original post

7 Replies
robert_mika
Master III
Master III

What is your desired results?

Anonymous
Not applicable
Author

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.

sunny_talwar

Try this may be:

Calculated Dimension: WeekStart(Date)

Expression: Sum(Measure)

Anonymous
Not applicable
Author

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

Regards,

Kumar

sunny_talwar

Is this not what you wanted?

Capture.PNG

Anonymous
Not applicable
Author

My apologize and it is working. Thanks a lot.

sunny_talwar

No worries...

I am glad it worked.

Best,

Sunny