topic How to get the last 7 days sales without using TODAY() function? in QlikView

How to get the last 7 days sales without using TODAY() function?

gireesh1216 — Wed, 25 Nov 2020 16:16:04 GMT

HOW TO GET LAST 7 DAYS SALES WITHOUT USING TODAY() FUNCTION?

If I select 1/25/2016 i need to display 7 days sales(1/18/2016 to 1/24/2016)

last 7 days sales is:119

please find attachment

Re: How to get the last 7 days sales without using TODAY() function?

swuehl — Tue, 24 May 2016 08:55:49 GMT

Maybe something like

=Sum({<Date = {">=$(=Date(Max(Date)-7,'M/D/YYYY'))<$(=Date(Max(Date),'M/D/YYYY'))"}>} Sales)

Re: How to get the last 7 days sales without using TODAY() function?

sunny_talwar — Tue, 24 May 2016 09:38:14 GMT

The expression is the same, but I usually right the expression out like this:

=Sum({<Date = {"$(='>=' & Date(Max(Date)-7,'M/D/YYYY') & '<' & Date(Max(Date),'M/D/YYYY'))"}>} Sales)

The reason I do this is because in case you wish to know what is the range you have added in your expression. You can grab the part between the dollar sign expansion (part in red) and paste it in a text box object to see the range:

='>=' & Date(Max(Date)-7,'M/D/YYYY') & '<' & Date(Max(Date),'M/D/YYYY')

This in a text box object should give you the required range in the format of your date field. If it is not, then you have a problem and need to fix this part for your set analysis to work.

Here is a sample:

When no selection

When we select another date

Re: How to get the last 7 days sales without using TODAY() function?

wcilliers — Mon, 28 Nov 2016 08:27:46 GMT

Hi Sunny,

I have a question to your post above. Please can you let me know if it is possible to have, in that same straight table that you have, a second column, that lists the last seven days for every date in the list? I don't necessarily want to have a date selected...

Hope that makes sense.

Thanks,

Re: How to get the last 7 days sales without using TODAY() function?

swuehl — Mon, 28 Nov 2016 09:38:28 GMT

You can use

The As-Of Table

to achieve what you want.