topic Re: Get current week number? in QlikView

Get current week number?

Wed, 23 Jul 2014 11:29:02 GMT

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?

struniger — Wed, 23 Jul 2014 11:31:26 GMT

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 — Wed, 23 Jul 2014 11:36:37 GMT

Use Week(Today())

Anonymous — Wed, 23 Jul 2014 11:49:09 GMT

Hi Try this

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

Wed, 23 Jul 2014 11:53:38 GMT

Thanks Stefan,

it works.

aveeeeeee7en — Wed, 23 Jul 2014 11:57:15 GMT

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

Wed, 23 Jul 2014 12:01:00 GMT

Thanks Nag,

actually this is not what I'm looking for.

but thank for your help and support.