topic Re: week day function cannot used on Qlikview Ver11. Any one have idea to get number of day in in QlikView

week day function cannot used on Qlikview Ver11. Any one have idea to get number of day in

Fonlovedog207 — Mon, 26 Jan 2026 16:26:21 GMT

My office have QlikView version 11, but week day function cannot used on QlikView Ver11 (On server scrip error but on desktop not error). Any one have idea to get number of day by example

Re: week day function cannot used on Qlikview Ver11. Any one have idea to get number of day in

MayilVahanan — Mon, 16 Jan 2023 09:56:10 GMT

Do you have day name info? and required the number like 0,1,2 ..

Then try like below

Match(UrDayNameField, 'Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat')-1 as Fieldname2

Re: week day function cannot used on Qlikview Ver11. Any one have idea to get number of day in

Fonlovedog207 — Mon, 16 Jan 2023 09:59:27 GMT

No i don't .I have date

Re: week day function cannot used on Qlikview Ver11. Any one have idea to get number of day in

MayilVahanan — Mon, 16 Jan 2023 10:12:44 GMT

okay, hope weekstart function will be there.. If so , try like below

=Pick(Match(Floor(urdatefield), Floor(WeekStart(urdatefield)), Floor(WeekStart(urdatefield)+1), Floor(WeekStart(urdatefield)+2), Floor(WeekStart(urdatefield)+3), Floor(WeekStart(urdatefield)+4), Floor(WeekStart(urdatefield)+5)
, Floor(WeekStart(urdatefield)+6)),
'Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat')

or change to 0,1,2,3..

Re: week day function cannot used on Qlikview Ver11. Any one have idea to get number of day in

marcus_sommer — Mon, 16 Jan 2023 15:39:05 GMT

Weekday() is a valid date-function within QV 11 and also within many releases earlier. If it's worked for you within the desktop client but not within the server it's quite likely that either the dataset is different or that different settings to the interpretation are applied. For example if no interpretation-variables are used QlikView takes the regional-settings from the OS and they may be different.