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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Kartik2
Partner - Creator
Partner - Creator

WeekNo

I want to get Weeknumber  from Date field but the week number must be like '1','2','3','4','5' only

according to that month ?

Labels (4)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try this : 

Ceil(Day(yourDate)/7) 

View solution in original post

2 Replies
tresesco
MVP
MVP

Try this : 

Ceil(Day(yourDate)/7) 

Kartik2
Partner - Creator
Partner - Creator
Author

Thanks @tresesco ,this worked !!!