Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dhavalvyas
Contributor III
Contributor III

week day number

Hi,

I have raw data contains data for two month.

1>while I am selecting date from first 7 days it will shoe week no as 1

2>similarly while I am selecting date 21 it will show week no as 3

so what is logic for that can any one suggest any solution ???

3 Replies
prat1507
Specialist
Specialist

maybe this

Num( Week(Date) ) - Week( MonthStart(Date) ) + 1


Regards

Pratyush

MK9885
Master II
Master II

In backend for your script the below would give you week...

week(YOURDATEFIELD) as Week

MarcoWedel

What are the week numbers of your second month?