topic Re: Separate the weekends in QlikView

Separate the weekends

yoganantha321 — Sat, 16 Nov 2024 21:43:31 GMT

Hi all,

I have a data set as list of dates with the type as shown in image1. But i need a new type as weekends as shown in image 2.

Anybody help in this!!!!

I have attached a sample file along with this.

Regards,

Yoganantha Prakash G P

Re: Separate the weekends

tresB — Mon, 17 Dec 2018 08:35:59 GMT

May be like:

If(Match(Weekday([End Day]), 'Sat', 'Sun'), 'Weekend', Type) as Type

Re: Separate the weekends

yoganantha321 — Mon, 17 Dec 2018 08:57:41 GMT

Hi Tresesco,
As shown in the first image in between the weekends appear it should be automatically generate start date and end date as shown image 2

Re: Separate the weekends

tresB — Mon, 17 Dec 2018 09:21:32 GMT

So first image is your input and second one is expected output, right? If so, could you explain the logic a bit more, like how exactly you get second row of End Date (7/12/2018)?

Re: Separate the weekends

uacg0009 — Mon, 17 Dec 2018 09:44:41 GMT

I think because the 8/12/2018 is Sat, so the vacation is till to 7/12/2018.

Re: Separate the weekends

yoganantha321 — Mon, 17 Dec 2018 10:03:40 GMT

Yes Tresesco!!!

As said by Uacg0009

Re: Separate the weekends

PradeepReddy — Mon, 17 Dec 2018 10:46:55 GMT

See the attachment..

the solution is little bit lengthy..

Re: Separate the weekends

yoganantha321 — Mon, 17 Dec 2018 11:16:06 GMT

Thanks Pradeepreddy

Re: Separate the weekends

uacg0009 — Tue, 18 Dec 2018 01:53:27 GMT

Actually last night, I also created a solution, but didn't upload it...

But it's fine, you can check my script.

Thanks

Aiolos