topic Re: How to only show current week (and year) in QlikView

How to only show current week (and year)

Meg00 — Thu, 02 May 2013 12:02:46 GMT

I have a small problem

I have a textbox in wich I want to show number of calls this week, now it looks like this (Flagga_Kontakt, represent number of incoming calls):

The problem here is that it shows the sum of calls from both this week 2013 and same week the past years. Any suggestions?

alexandros17 — Thu, 02 May 2013 12:09:45 GMT

you need a field "year"

to add the condition in set analysis year={$(=year(today()))}

hope it helps

Thu, 02 May 2013 12:11:03 GMT

=sum({$<Week={$(vThisWeek)}, Year={$(vThisYear)}>} Flagga_Kontakt)

Put into your variables :

LET vDateToday = num(Date(Today(), 'YYYY-MM-DD'))

or you could just say

Let vThisYear = num(Year(Today())

Let vDateToday = num(Today())

LET vThisWeektext = Week(vDateToday);

Remember if you use variaables with dates and not NUM infront, you need to put ' ' before your variables in your expression

Thu, 02 May 2013 12:14:51 GMT

sum({<year={$(=year(today()))}, Week={$(=week(today()))}>} Flagga_Kontakt)

Meg00 — Thu, 02 May 2013 12:19:32 GMT

This shows the exact same numbers as before. It still shows totals of all years.

Thu, 02 May 2013 12:22:01 GMT

try this

sum({<year={$(=year(today()))}, Week={$(=week(today()))}>} Flagga_Kontakt)

Meg00 — Thu, 02 May 2013 12:25:13 GMT

Thank you, that worked just fine!