How to Sum Total for Week in Group?

[#1]

Hi All,

I need to sum up the calls for each week and the total for the week needs to remain even if I select month, year, date etc... The sum total only gives me the grand total.

The week is active so the result of call offered is what I need in the new column. Would someone please show me how to achieve this?

Thank you for your help everyone.

[sinanozdemir]

Hi,

May be try this:

Sum(Total<[Day of Week]> count)

So use the week dimension within Total<>.

Hope this helps.

[#3]

Hi Sinan,

It does not matter what I put in < >, it still show the grand total, 558,033, for result. Do you have other idea? Thank you for your input.

[Anonymous]

You can use the WeekStart function:

Ex: WeekStart(field date)

[#5]

Hi Marcio,

I am new to Qlikview, would you please collaborate?

Thank you.

[neelamsaroha157]

Can you share some sample data and define what out you expect...

[Anonymous]

phong do,

Can you send an example to try to help you?