topic Chart that shows current year and (current - 1) week in QlikView

Chart that shows current year and (current - 1) week

Anonymous — Mon, 26 Jan 2026 16:26:21 GMT

Hi, QlikView

I have data set that shows sales number and date when they happen.

I want to make a chart what shows sales numbers for each day in the last week (current - 1) and only current year.

I will explain better. So today is 30.09.2015 which is week 40 in the year 2015.

I want the sales number to show week 39 in the year 2015.

I used this formula: =sum({<Year={$(=year(today()))}, Week={$(=week(today()))}>} Sales)

to show sales number for current week and current week.

What can I do to get week 39 in the year 2015

Kushal_Chawda — Wed, 30 Sep 2015 14:06:32 GMT

try this

=sum({<Year={"$(=max(Year))"}, Week={"$(=max(Week)-1)"}>} Sales)

Anonymous — Wed, 30 Sep 2015 14:34:13 GMT

hi, Kush141087

This formula does not work. The chart gives me this text: "No data to display"

Can you make it work in the Sales data per day.qvw

giakoum — Wed, 30 Sep 2015 14:42:27 GMT

Based on your formula, this works :

=sum({<Year={$(=year(today())-1)}, Week={$(=week(today())-1)}>} Sales)

Please note that you have no data for 2015, week 39, that is why I also used year-1

There is data for 2014, week 39

pamaxeed — Wed, 30 Sep 2015 14:47:05 GMT

The formula of Ioannis is right, you just do not have data for week 39 for the current year.

Patric

maniram23 — Wed, 30 Sep 2015 15:35:16 GMT

Hi,

try this one. it is helpful for you

=sum( {<year={$(=max(Year))}>}Sales)