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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
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.