topic Re: Selecting current week and last week in QlikView

Selecting current week and last week

bobbydave — Sat, 16 Nov 2024 04:55:47 GMT

VLN_Date is made up from the filename. I have

12-11-2018

19-11-2018

26-11-2018

03-11-2018

10-12-2018

17-12-2018

I only ever want the last weeks so I need the 17th and the 10th in this case.

count({<VLN_Date = {'$(=Max({1}VLN_Date))'}>}Description) - THE CURRENT WEEK 17TH

COUNT({< VLN_Date = {"$(=Date(Max({1}VLN_Date)-7, 'DD-MM-YYYY') "} >} Description) - THE PREVIOUS WEEK 10TH

Of course this doesn't want to work for me.

Any help appreciated.

Re: Selecting current week and last week

sunny_talwar — Wed, 19 Dec 2018 16:13:03 GMT

Can you try this

Current Week

Count({<VLN_Date = {"$(=Date(Max({1}VLN_Date), 'DD-MM-YYYY'))"}>}Description)

Previous Week

Count({<VLN_Date = {"$(=Date(Max({1}VLN_Date) - 7, 'DD-MM-YYYY'))"}>} Description)

Re: Selecting current week and last week

rubenmarin — Wed, 19 Dec 2018 21:01:11 GMT

Hi, how are you reading data from filename? maybe it's being loaded as a string , not a number (or date).

In this case you can try setting the input format with date#():
Date#(Left(Filebasename(), 10), 'DD-MM-YYYY') as VLN_Date

Change Left(Filebasename(), 10) with your current expression to extract date.

Re: Selecting current week and last week

bobbydave — Thu, 20 Dec 2018 08:35:17 GMT

Thanks Sunny.
Worked like a dream