topic Re: How to calculate previous week in QlikView

How to calculate previous week

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

Hi,

I need to show previous week's data from the attached QVD based on the current date, means current date's previous week will be calculated and data will have to be shown according to that week.

Please let me know how to achieve that.

Thanks,

Sandip

Re: How to calculate previous week

Anonymous — Sun, 16 Apr 2017 08:08:51 GMT

Hi,

When you say current date based on data, do you mean the max date ? because in your data you don't have 2017...

So If i understanfd you want the previous week of max date's data. In that case may be week(max(orderdate))-1

Re: How to calculate previous week

ananyaghosh — Sun, 16 Apr 2017 08:29:52 GMT

hi,

your expression is wrong and it gives me no data.

Re: How to calculate previous week

Anil_Babu_Samineni — Sun, 16 Apr 2017 08:44:08 GMT

Finally, You want to do this in Script level. Here, Which date you meant to say - 27/12/2015 ??

Re: How to calculate previous week

ananyaghosh — Sun, 16 Apr 2017 09:41:53 GMT

yes, based on the order date. So if I choose 27/12/2015, then it will show the sum(slaes vales) based on the previous week of the selected date.

So please suggest a way of how to do that.

Thanks,

Sandip

Re: How to calculate previous week

Anil_Babu_Samineni — Sun, 16 Apr 2017 12:48:49 GMT

May be try this in straight table with dim as [Order Date]

Sum({<[Order Date] = {'$(=Date(Max([Order Date])-7))'}>}Sales)

Re: How to calculate previous week

el_aprendiz111 — Sun, 16 Apr 2017 16:03:08 GMT

Hi,

in SCRIPT:

NUM(Week([Order Date]-7),'00') AS _WEEK,

Re: How to calculate previous week

Sun, 16 Apr 2017 17:39:54 GMT

Hi Sandip,

Please see below and qvw attached. Any good?

Re: How to calculate previous week

Anonymous — Sun, 16 Apr 2017 18:16:11 GMT

Sorry i didn't really understand your needs

May be it will helps you

Re: How to calculate previous week

shamitshah — Mon, 17 Apr 2017 02:43:39 GMT

Hi Sandip,

Have a look at the attached. I have created some variables and included two text boxes.

By selecting any date from the list box will show the sales for that date in one text box. The other text box will show the sales for the other date (7 days prior).

Re: How to calculate previous week

parul_mehta — Mon, 17 Apr 2017 10:53:00 GMT

Please try this for the previous week calculation based on Order Date

Sum({<[Order Date] = {'$(=Date(Max([Order Date])-7))'}>}sales)

Re: How to calculate previous week

parul_mehta — Mon, 17 Apr 2017 13:02:06 GMT

Please check this. It works for last week calculation

Re: How to calculate previous week

Thu, 20 Apr 2017 12:09:18 GMT

Hi Sandip,

Hope you are well.

Have you had a chance to look at the replies yet?