topic Re: Previous Week date in QlikView

Previous Week date

mosha231 — Tue, 28 Nov 2017 12:30:51 GMT

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 — Tue, 28 Nov 2017 12:33:20 GMT

Year((today()-7))

Regards,

PrashantSangle — Tue, 28 Nov 2017 12:37:22 GMT

Hi,

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

gives you previous weekstart.

Regards,

mosha231 — Tue, 28 Nov 2017 12:39:26 GMT

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 — Tue, 28 Nov 2017 12:52:28 GMT

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

Regards

mosha231 — Tue, 28 Nov 2017 13:51:21 GMT

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 — Wed, 29 Nov 2017 05:37:09 GMT

Hi,

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

use

WeekName(Today())

navigate below URL to learn more date and time function

Regards,

raviteja475 — Wed, 03 Jul 2019 11:34:34 GMT

Hi,

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

Thank you,

raviteja