topic Previous week Date in QlikView

Previous week Date

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

Hi team,

Thanks in advance for your attention .

Here my problem statement is that I want to have previous week Thursday date if in my table if today is not Thursday.

Means my dimension should have date of Thursday only ,if today is Monday than it should show previous Thursday's date.

Thanks,

Re: Previous week Date

vinieme12 — Wed, 11 Jan 2017 11:02:54 GMT

Try

=if(Weekday(Today())=3,Today(),date(Today()-(num(WeekDay(today()))+4)))

Re: Previous week Date

eromiyasimon — Wed, 11 Jan 2017 11:13:47 GMT

=date(date#(Today(),'MM/DD/YYYY')-7,'DD/MM/YYYY')

use this

Re: Previous week Date

Wed, 11 Jan 2017 11:15:07 GMT

Hi,

Sorry

I am not clear with your question could you please elaborate ?

Also weekday() Function will return only string values not numeric values.

So weekday(Today()) will only return today's day name and not 3 or 4.

Thanks.

Re: Previous week Date

vinieme12 — Wed, 11 Jan 2017 11:48:03 GMT

Weekday() is a dual function, you can read more about it in help

Re: Previous week Date

MarcoWedel — Wed, 11 Jan 2017 23:03:24 GMT

Hi,

one solution might be:

Date(Floor(YourDate,7,5))

tabDates:
LOAD *,
     Date(Floor(YourDate,7,5)) as PreviousThursday;
LOAD Date(YearStart(Today())+RecNo()-1) as YourDate
AutoGenerate 50;

hope this helps

regards

Marco

Re: Previous week Date

Anonymous — Thu, 12 Jan 2017 10:43:20 GMT

Hi Marco,

Thanks for your reply, but I have not to use any base dimension, means I have to add one dimension which should so Thursday's date without dependency on any dimension.

Thanks,

Pooja

Re: Previous week Date

MarcoWedel — Thu, 12 Jan 2017 19:36:25 GMT

Hi,

that's just been an example to demonstrate this expression's results.

Instead of

Date(Floor(YourDate,7,5))

you could also use

Date(Floor(Today(),7,5))

hope this helps

regards

Marco