Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Value by Week No Per Month

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?

Labels (1)
1 Reply
swuehl
Champion III
Champion III

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.