how to pull out data of last week between Sunday to Saturday?

[harleen_singh]

Hii,

how to pull out data of last week between Sunday to Saturday? I have a date field present.

I think qlikview treats Monday as a first day of week.

But i need to instruct Sunday as a first day of week.

thanks

Lavi

[#2]

hello,

try to change with the variable DayNames in loading script

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

--> SET DayNames='Sun;Mon;Tue;Wes;Thu;Fri;Sat';

[#3 · Accepted solution]

Hi,

Use InWeek function.

like

InWeek ( date, today(), -1, -1) this will start loading data from 00:00 HRS of Sunday last week to Saturday 24:00 HRS last week.

Reg,

Shubhu