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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sevvalk
Creator
Creator
‎2025-01-20 01:50 AM

Set the week number

Hi,

I want to set the week number. This week of number is 3. But in report this week of number is 4 with this settings.

How i change this?

sevvalk_0-1737355796608.png

 

479 Views
0 Likes
3 Replies
Chanty4u
MVP
MVP
‎2025-01-20 03:37 AM

Try to change below 

SET BrokenWeeks=0; // 0 = First week is first full week, 1 = Allow partial weeks

Week(DateField) AS WeekNumber

 

451 Views
0 Likes
sevvalk
Creator
Creator
‎2025-01-20 03:55 AM
Author

In response to Chanty4u

It doesn't work

447 Views
0 Likes
henrikalmen
Specialist II
Specialist II
‎2025-01-20 08:29 AM

Set ReferenceDay according to your needs. See https://help.qlik.com/en-US/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTim... 

425 Views
0 Likes