topic Re: Formula in text box in QlikView

Formula in text box

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

Hi, QV community

I have one problem that needs solving.

I have data for the sale of my company for every day.

I wanted to make a big text box that says "Sales in & last(YrWk)

But my problem is of course that the date is always changing so I have to make a formula in my text box

Let me explain this better:

So today is the date 5.11.2015 so that makes it week 45 in the year 2015 or 2015-Wk45 in my data.

So last week was 2015-Wk44.

So I need a formula in the text box that says Sales in 2015-Wk44

regards Darri

Anonymous — Thu, 05 Nov 2015 09:18:47 GMT

you can use predefiend function weekname (instead of "-" uses "/"

='Sales in ' & WeekName(today()-7)

tresB — Thu, 05 Nov 2015 09:22:58 GMT

Try like:

=Sum({<YrWk={"$(=Year(Today())&'-Wk'&(Week(Today())-1))"}>}Sales)

Anonymous — Thu, 05 Nov 2015 09:29:31 GMT

That is what I am looking for but I would like to have 2015-Wk44 so the users knows exactly what I the data is showing.

I feel like 2015/44 not explain good enough that it is week 44.

You have any idea to show Wk44

Anonymous — Thu, 05 Nov 2015 09:36:14 GMT

use

='Sales in ' & Year(Today())&'-Wk'&(Week(Today())-1)

the function tresesco suggested (but only get text instead of sum)