Previous Week date

[mosha231]

Hi all,

I am trying to get 7 days back date from system date in qlikview.  and then fetch year of that date.

example - Today is 1/01/2017  then i want  25/12/2016 date and in year it should show 2016

THANKS in ADVANCE!!

[PrashantSangle · Accepted solution]

Year((today()-7))

Regards,

[PrashantSangle]

Hi,

You can also use weekstart(today(),-1)

gives you previous weekstart.

Regards,

[mosha231]

Thanks for your quick reply.

For year it is working fine. but when i do (Today() - 7) am not getting required date format is coming up as different

[PrashantSangle]

use date(Today()-7,'YourDateFormat')

Regards

[mosha231]

going forward on this. can you tell how i can join two outputs.

example year(today())  gives me 2017 and week(today()) gives me 48. i want output to be 201748

Thanks Allot

[PrashantSangle]

Hi,

year(today())&week(today())

or

use

WeekName(Today())    

navigate below URL to learn more date and time function

Date and time functions ‒ QlikView

Regards,

[raviteja475]

Hi,

Have you got the answer can you please help me how to get present and previous week transactions

Thank you,

raviteja