topic Re: current week ,Previous week in QlikView

current week ,Previous week

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

Hi all,

i got a requirement like my week starts from sat and ends on Friday so here i wanted to show completed week , and previous week

suppose my data is updated on 17/4/2016 its incomplete week bcos its in between Sat-Fri so here i want to show only completed week and previous week as s well

=If(Max(Date_Trans) < Floor(Weekend(Max(Date_Trans),0,5)),Date(Max(Date_Trans),

Date(Floor(Weekend(Max(Date_Trans),0,5))))

)

this gives me incomplete week ,complete week

Re: current week ,Previous week

sunny_talwar — Wed, 20 Apr 2016 08:19:22 GMT

this gives me incomplete week ,complete week

I don't think I understand this last line. What exactly is the issue and what are you trying to do?

Re: current week ,Previous week

nareshthavidishetty — Wed, 20 Apr 2016 08:35:44 GMT

hi sunny thanks for the reply

i just want to show the current completed week suppose my week starts from saturday and ends on fri and my data gets uploaded daily,think it is updated until 17/4/16 and it becomes incomplete ,does it make sense so here i want to show only completed week means till 15/4/2016 and previous week 8/4/2016

thanks

Naresh