Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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?