WeekStart From Sunday-Saturday

[sat_tok52]

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]

Change from default

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

[sunny_talwar]

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

SET FirstWeekDay=6;

Also, look here:

FirstWeekDay ‒ QlikView‌

[qlikview979]

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]

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

Redefining the Week Start

[qlikview979]

Hi May be this

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

Reards,

Mahesh