Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Mark week number

Hi all,

This might be rather a simple one but I couldn't get this to work.

I have two date fields from two different table and I populated a new field call timegap using the difference of two date fields. Now i want to create a week field which will be based on timegap field. so if the timegap is 1-7 its week 1, 8-14 its week 2 etc upto week 12 .

Thank you

Naveen

1 Solution

Accepted Solutions
sunny_talwar

May be like this

'Week ' & Ceil(timegap/7) as NewField

View solution in original post

2 Replies
sunny_talwar

May be like this

'Week ' & Ceil(timegap/7) as NewField

Not applicable
Author

That worked. Thanks