topic Re: completed week vs incompleted week in QlikView

completed week vs incompleted week

nareshthavidishetty — Mon, 18 Apr 2016 07:14:44 GMT

hi all,

can any one help me as i struck with the requirement

i want to know whether the week is completed or not as my week starts from Saturday ends on friday, my data will be uploaded daily bases so think that data is uploaded till 13 of this month which is incomplete week bcos complete week is till 15/4/2016,so please tell me how to find complete week

thanks in advance

Re: completed week

swuehl — Mon, 18 Apr 2016 07:18:42 GMT

Not having real an idea what you are trying to do. Seems your weeks end on Friday? But you want to show Wednesday?

Maybe it's just enough to subtract 2 days:

max(Date(SubField(FiscalWeek,'_',2) -2 ))

Re: completed week

Gysbert_Wassenaar — Mon, 18 Apr 2016 07:19:03 GMT

Please read these two documents:

Re: completed week

Colin-Albert — Mon, 18 Apr 2016 07:20:56 GMT

I would guess that your week is defined as Monday - Sunday, so the max function is returning the last day of the week hence Sunday.

Try Date(max(Date(SubField(FiscalWeek,'_',2))) -2)

Re: completed week

Anonymous — Mon, 18 Apr 2016 07:52:25 GMT

Load

Subfield( FiscalWeek, '-', 1) as current,

Subfield( FiscalWeek, '-', 2) as current1,

Subfield( [FiscalWeek, '-', 3) as current2

Resident table name

Re: completed week

nareshthavidishetty — Mon, 18 Apr 2016 08:24:48 GMT

im sorry for the unclear question as my week starts from Saturday and ends on friday.my data is uploaded daily so they uploaded until 13/4/2016 so i want to display that date instead of 15/4/16

Re: completed week vs incompleted week

nareshthavidishetty — Mon, 18 Apr 2016 09:30:07 GMT

HI thanks for the response and sorry for not explaning clearly

Re: completed week vs incompleted week

swuehl — Mon, 18 Apr 2016 09:37:23 GMT

Maybe like

=If(Max(Date) < Floor(WeekEnd(Max(Date),0,5)),'Incomplete','Complete')

Re: completed week vs incompleted week

nareshthavidishetty — Mon, 18 Apr 2016 09:52:34 GMT

thanks for the help

Re: completed week vs incompleted week

nareshthavidishetty — Mon, 18 Apr 2016 11:18:41 GMT

hi Swuehi,

is it possible to display the dates instead of complete,incomplete

Re: completed week vs incompleted week

swuehl — Mon, 18 Apr 2016 12:04:38 GMT

Sure, why not just replace the strings with your dates?

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

Date(Max(Date)),

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

)

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

'Incomplete: Last update on ' & Date(Max(Date)) ' instead of ' & Weekend(Max(Date),0,5),

'Complete: Last update on ' & Date(Max(Date))

)

Or whatever you want to show.

Re: completed week vs incompleted week

nareshthavidishetty — Tue, 19 Apr 2016 05:06:36 GMT

thanks for the reply

Re: completed week vs incompleted week

nareshthavidishetty — Wed, 20 Apr 2016 05:19:36 GMT

Hi Swuehi,

instead of incomplete week i want to show complete week and previous complete week in the expression can you tell me how to write the expression,so here i don't want incomplete 15/4/2016 week to show only completed week 8/4/2016 and previous completed week 1/4/2016

thanks very much

Naresh

Re: completed week vs incompleted week

swuehl — Tue, 26 Apr 2016 15:54:34 GMT

You can get the previous weekend and the one before using something like

Weekend(Max(Date),-1,5)

resp.

Weekend(Max(Date),-2,5)