topic Re: Issue with default selection current year ,with current month's max week in QlikView

Issue with default selection current year ,with current month's max week

ferha_jafri — Wed, 21 Aug 2013 07:13:05 GMT

Hello Everyone,

I have an issue with current selection.As per client req. when nothing is selected for year,month and week then default selection should select current year,current month with max week of that month.I have week as 1,2,3,4,5....and so on so my issue is that when i write an expression for current selection with max month and max week it is selecting 53 week and 12 month...please help me on this it is urgent as need to show the client by end of the day

Thanks in advance

Ferha Jafri

Re: Issue with default selection current year ,with current month's max week

sparur — Wed, 21 Aug 2013 07:24:27 GMT

hi. I think you should create an Action for autoselect values and attach this Action for OnOpen document trigger.

in the action you should create 3 Actions with such sequence: Year -> Month -> Week

Expressions should be like this:

for Year: =year(Today())

for Month: =month(Today())

for week: =max(Week)

If you don't want create special sequence, you can create special expression for week like this:

=max({<Month = {$(=month(today()))}>} Week)

Re: Issue with default selection current year ,with current month's max week

ferha_jafri — Thu, 22 Aug 2013 05:23:16 GMT

Thank you so much it worked for me