topic Current week/year Default Selection in QlikView

Current week/year Default Selection

Thu, 25 Apr 2013 14:49:02 GMT

Hi.

i am looking to set current week as a default selection.

i have created a trigger (based on object name week) as following

weekyear(today(week))

However this is not working.

attached is a sample file.

Best,

Bradley

Re: Current week/year Default Selection

Gysbert_Wassenaar — Thu, 25 Apr 2013 18:41:21 GMT

The weekyear function returns an integer value representing a year. For example weekyear( '1996-12-30' ) returns 1997. The today() function can make use of 0,1 or 2 as parameter. Anything else won't do anything. So weekyear(today(week)) won't do what you want. At best it returns the current year.

Depending on what kind of data type week_year has you need either a date, in which case today() should suffice, or you need to construct a string: year(today()) & '/' & week(today())

Re: Current week/year Default Selection

Thu, 25 Apr 2013 19:50:16 GMT

Hi Gysbert!

This works great,thanks for the advice.

is it possible to change the value once default selection is on?

Re: Current week/year Default Selection

Gysbert_Wassenaar — Fri, 26 Apr 2013 09:16:30 GMT

A default selection is just a selection. So you can make new selection if you want. Just click on another value to select that. Pressing the Clear button would also remove it.

Re: Current week/year Default Selection

Sat, 27 Apr 2013 19:03:38 GMT

Hi Gysbert!

thanks for all the advise. However, in my case i have the problem that when the action is set on the field, it is impossible to remove the default selection value.

i have attached the qvw to the original message for further clarity.

i suppose there is a parameter setting i have missed?

Best,

Bradley

Re: Current week/year Default Selection

Sun, 28 Apr 2013 09:02:00 GMT

This Problem is now Solved.

To ensure Default selection and the ability to change the default you need to set a trigger on on the field event with the selection OnSelect (Edit Action) and OnChange.

Thank you for your help once again.

OnChange

Week

OnSelect

week(today())

Re: Current week/year Default Selection

Gysbert_Wassenaar — Sun, 28 Apr 2013 13:56:46 GMT

Well, that's because you added it to the field trigger. What happens now is that any time the selection in Week changes the selection is set to the week of today(). So if you choose week 2 the trigger fires and value 17 is selected.

Just remove it from the field trigger and leave the action on the sheet trigger. You can also add the same action to the OnOpen document trigger so the right week is set when you open the document.