Show week total

[CreepyCatLady]

Hi, I am new to Qlik and learning as I go, so please forgive me if this is a simple question.

I need to show totals of how often a specific application has been used. I can easily show daily totals, like this:

But what I need to show are weekly totals. How do I sum the Details field by week?

Thank you!

[Taoufiq_Zarra · Accepted solution]

@CreepyCatLady  if i understood correctly you need to change you dimenison to

=weekname(if(LocalDate >'5/31/2019' and LocalDate <today(),LocalDate))

[CreepyCatLady]

I think I tried every possible combination of those elements besides this one. This worked perfectly, thank you so much.

[CreepyCatLady]

@Taoufiq_Zarra one more question, if you don't mind. Is there a way I can get this to cut off at the end of the previous week (currently, it goes up to today, which makes it look like usage drops way down on a Monday or Tuesday)? I tried changing "weekname" to "weekend" but it still goes all the way to current day. 

Thank you so much for your help.

[Taoufiq_Zarra · Accepted solution]

@CreepyCatLady  like ?

=weekname(if(LocalDate >'5/31/2019' and LocalDate <Date(weekstart(today())-1),LocalDate))