Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get current week number?

I have a calendar table, I need to set a filter always to current week number

Week number is already in the calendar tale

Now based on today date. I can get the week number

But the furmual is not working

vToday = today()

=max( {< CalendarDate= {'$(vToday)
'} >} 
CatalogWeek)

Any idea how this can work?

1 Solution

Accepted Solutions
djlagaffe
Creator
Creator

Try to add this to your calendar table as a flag, then select the flag = 1

inweek(CalendarDate, '$(vToday)', 0) * -1 AS CW

Best regards

Stefan

View solution in original post

6 Replies
djlagaffe
Creator
Creator

Try to add this to your calendar table as a flag, then select the flag = 1

inweek(CalendarDate, '$(vToday)', 0) * -1 AS CW

Best regards

Stefan

View solution in original post

mahesh_agrawal
Creator
Creator

Use Week(Today())

venkatasreekant
Specialist
Specialist

Hi Try this

='Week Number ' & ' - ' & Week(Today())

Not applicable
Author

Thanks Stefan,

it works.

aveeeeeee7en
Specialist III
Specialist III

Try this:

=Only ({<Week= {'$(=Max(Week))'} >} Date)

Here Week is which you have created by using your date field eg.  Week(DateField) AS Week and Date is your DateField

See the Attachment.

Regards

Aviral Nag

Not applicable
Author

Thanks Nag,

actually this is not what I'm looking for.

but thank for your help and support.