topic Value by Week No Per Month in QlikView

Value by Week No Per Month

Tue, 31 Jul 2012 11:20:52 GMT

Does QlikView support week numbering by Month?

For example, I would like to analyse our Sales Value for each Week No of the year by a Month

To explain

If Feb included weeks 5, 6, 7 and 3 days of 8 and March included 4 days of week 8 and weeks 9 to 11, then the sales values should be apportioned.

Is this possible?

Re: Value by Week No Per Month

swuehl — Tue, 31 Jul 2012 11:39:56 GMT

Do you have sales values in your table per date or per week?

If per date, just create a year, month, week field from date using year(date), month(date), week(date) and create a table chart with dimensions year, month, week and sum(sales) as expression.