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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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())).