topic Re: WeekStart From Sunday-Saturday in QlikView

WeekStart From Sunday-Saturday

sat_tok52 — Wed, 28 Sep 2016 11:47:27 GMT

Hi All,

Currently My date Column is giving week from Monday-Sunday,but My user want see week should be Sunday-Saturday,How can I change .Any Help.

Thanks,

Sateesh

Anil_Babu_Samineni — Wed, 28 Sep 2016 11:54:04 GMT

Change from default

SET DayNames='Sun;Mon;Tue;Wed;Thu;Fri;Sat';

sunny_talwar — Wed, 28 Sep 2016 11:54:21 GMT

Play around with this variable in the environmental variable in the script

SET FirstWeekDay=6;

Also, look here:

qlikview979 — Wed, 28 Sep 2016 11:55:31 GMT

Hi If you want only

Saturday,

Sunday

May be this

LOAD ID,

PRODUCT,

SALES,

weekday(DATE) as DATE,

FROM

Source

(ooxml, embedded labels, table is Sheet1) Where match(WeekDay(DATE),'Sat','Sun');

Colin-Albert — Wed, 28 Sep 2016 12:01:28 GMT

This blog explains how to set the week start for both QlikView and Sense

qlikview979 — Wed, 28 Sep 2016 12:01:42 GMT

Hi May be this

SET DayNames='Sun;Mon;Tue;Wed;Thu;Fri;Sat';

Reards,

Mahesh