Button to Select data available weeks to date

Mon, 09 May 2011 11:53:22 GMT

Good afternoon

I need to create a button which when pressed selects all of the available weeks for the present year, i.e If I were to press the button today it would select the first 19 weeks, If I press it next week it would select the first 20 weeks.

Within a button you can set an action "select in field" where im using a week of a created date and <=19 in the criteria and this works fine. However using a function like =$(<=week(today())) the button stops working.

Any help would be appreciated.

Regards

Shaun

Button to Select data available weeks to date

Anonymous — Mon, 09 May 2011 12:29:47 GMT

Hi Shaun,

I think I found it:

Try this : = '<=' & Week(today())

Good luck.

Button to Select data available weeks to date

Mon, 09 May 2011 12:42:18 GMT

ooo I like it. That works perfectly.

Thanks

topic Button to Select data available weeks to date in QlikView

Button to Select data available weeks to date

Button to Select data available weeks to date

Button to Select data available weeks to date