topic Re: Weekly Sales in QlikView

Weekly Sales

Fri, 31 Jan 2014 10:44:27 GMT

hi all,

please Find Attachment

am sending weekly Rolling Days calculation

Can any one modifies The Below Qvw File With more Efficient Way

i have Done but don't think it efficient way of doing this

For Following task

1)how to create Manual weeks??

i have 1-27 dates

i want

1-7 as first week

8-14 2nd week

15 -21 as 3 rd Week

22-27 as 4th week

in front end

2) and how to create Weekly Sales for Comparison current Week vs previous week of the month

Re: Weekly Sales

Fri, 31 Jan 2014 11:08:35 GMT

below links may help u...

http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/27/week-numbers

http://community.qlik.com/docs/DOC-5773

Re: Weekly Sales

MK_QSL — Fri, 31 Jan 2014 12:04:39 GMT

You can use below script to get weeknumber as per your requirements.

Data:

LOAD S_Date,

Sales

FROM

[New Microsoft Office Excel Worksheet.xlsx]

(ooxml, embedded labels, table is Sheet1);

// ****************Creating the Master Calendar *************

Temp_Calendar_Range:

LOAD

Date(Min([S_Date]), 'DD/MM/YY') as MinDate,

Date(Max([S_Date]), 'DD/MM/YY') as MaxDate

RESIDENT [Data];

LET vMinDate = Num(Peek('MinDate', 0, 'Temp_Calendar_Range'));

LET vMaxDate = Num(Peek('MaxDate', 0, 'Temp_Calendar_Range'));

LET vToday =num(today());

DROP TABLE Temp_Calendar_Range;

DateField:

LOAD

date ($(vMinDate) + rowno() -1) as TempDate

AUTOGENERATE

$(vMaxDate)- $(vMinDate)+1;

MasterCalendar:

LOAD

TempDate as [S_Date],

Day(TempDate) as Day,

WeekDay (TempDate) as Weekday,

Week(TempDate-1) as Week,

Month(TempDate) as Month,

Num(Month(TempDate)) as MonthNO,

Year(TempDate) as Year,

'Q' & ceil(month(TempDate) / 3) as Quarter,

Date (monthstart (TempDate) , 'MMM YYYY') as MonthYear,

Week(TempDate)&'-'&Year(TempDate) as WeekYear

RESIDENT DateField

ORDER BY TempDate ASC;

DROP TABLE DateField;

Re: Weekly Sales

MK_QSL — Fri, 31 Jan 2014 12:18:53 GMT

Please check enclosed file...

Re: Weekly Sales

Fri, 31 Jan 2014 14:00:39 GMT

Hi,

I hope this would help you in the dimension expression for ur chart.

=Pick(Num(Week(S_Date)),'W1','W2','W3','W4','W5')

Regards,

Venkat

Re: Weekly Sales

Mon, 03 Feb 2014 13:08:35 GMT

but in this when we click certain Date I doesn't Show comparison