completed week vs incompleted week

[nareshthavidishetty]

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

[swuehl]

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 ))

[Gysbert_Wassenaar]

Please read these two documents:

• QlikCommunity Tip: How to get answers to your post?‌
• Preparing examples for Upload - Reduction and Data Scrambling

[Colin-Albert]

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)

[Anonymous]

Load

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

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

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

Resident table name

[nareshthavidishetty]

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

[nareshthavidishetty]

HI thanks for the response and sorry for not explaning clearly

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

[swuehl · Accepted solution]

Maybe like

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

[nareshthavidishetty]

thanks for the help

[nareshthavidishetty]

hi Swuehi,

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