Discussion board where members can get started with QlikView.
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 ???
Num( Week(Date) ) - Week( MonthStart(Date) ) + 1
In backend for your script the below would give you week...
week(YOURDATEFIELD) as Week
What are the week numbers of your second month?