topic Re: create flag for working days and weekends? in QlikView

create flag for working days and weekends?

Thu, 08 Jan 2015 12:09:57 GMT

hi to all i am new in qlikview

can any one clarify me flag creating for working days and weekends.for ur handy i am sharing here "master calender qvd" file

Re: create flag for working days and weekends?

rubenmarin — Thu, 08 Jan 2015 12:25:17 GMT

Hi Maruthi,

From the qvd i flagged weekend like this:

LOAD *,

If(WeekDay(Date)>=5, 1, 0) as _IsWeekend

If(WeekDay(Date)<5, 1, 0) as _IsWorkingDay // Not really needed as you can ask for _IsWeekend=0

FROM [.\Master_Calender.qvd] (qvd);

WeekDay may change from different countries, in mine, 5 are for saturday and 6 for sunday, change it according to your configuration.

Maybe you'll need a table that identifies local or national parties to flag as non-working days.

Re: create flag for working days and weekends?

datanibbler — Thu, 08 Jan 2015 12:28:23 GMT

Hi maruthi,

that's quite easy. You have the WEEKDAY() function in QlikView (when you look that up in the Help_file, you'll get a list of all time- and date-functions, unfortunately all on one page) - that will, if I remember correctly, return a number. Depending on your system, weekends will be 1 and 7 or 6 and 7 - counting from Mon or from Sun.

Just use that in an IF_function to create a binary field with a 1 for weekdays and 0 for weekends.

HTH

Best regards,

DataNibbler

Re: create flag for working days and weekends?

Thu, 08 Jan 2015 12:31:48 GMT

Thank u Ruben

i am very much satisfied by ur answer ...

Re: create flag for working days and weekends?

Thu, 08 Jan 2015 12:32:13 GMT

Thank DataNibbler