Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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
struniger
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
struniger
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

mahesh_agrawal
Creator
Creator

Use Week(Today())

venkatasreekanth2020

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.