Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist
Specialist

maybe this

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


Regards

Pratyush

Highlighted
Master II
Master II

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

week(YOURDATEFIELD) as Week

Highlighted

What are the week numbers of your second month?