Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get 2nd week from Calender?

How to get 2nd week from Calender?

I required expression for it.

2 Replies
tresesco
MVP
MVP

if you are looking for date range from a Date field, you can try the following expression in an expression of list box:

 

=

If(week(YourDateField)=2,YouDateDate

Not applicable
Author

try this

if(week(Date(datefield))=2,Date(datefield)).

suppose today date is 14/06/2013 and its week is 24.

if(week(today())=24,week(today())).