topic Re: Current year as default selection in QlikView

Current year as default selection

Wed, 16 Jul 2014 14:18:19 GMT

Hi All,

I need the current year to be automatically selected when a user opens the report. I have tried using the Document Properties > Triggers > OnOpen but that didn't work for me. Can anyone give me some pointers on how to do this? Maybe an example?

Thanks.

Re: Current year as default selection

alexandros17 — Wed, 16 Jul 2014 14:24:03 GMT

Right place,

in the actions select add, then "Select in field" and write in the upper box: year (your field name)

in the lower box: =year(today())

let me know

Re: Current year as default selection

sasikanth — Wed, 16 Jul 2014 14:35:53 GMT

HI ,

Please find the attachment ,

i have enabled both Document level as well as Sheet level

Re: Current year as default selection

Wed, 16 Jul 2014 14:37:01 GMT

Thank you for your response. For some reason, it does not work. I have attached the image of what it looks like. Can you please check? Thanks.

Re: Current year as default selection

sasikanth — Wed, 16 Jul 2014 14:43:19 GMT

There field Should be

Year([Budget Year Description])

searching string is

=max(Year([Budget Year Description]))

Make sure "Year([Budget Year Description])" is your Year Field

Re: Current year as default selection

Wed, 16 Jul 2014 14:45:52 GMT

Hi, I worked with your example and it did not work either. Attached is the image. Any suggestions?

My data looks like FY13, FY14, FY15. Could it be because the data is not only integers?

Thanks.

Re: Current year as default selection

sasikanth — Wed, 16 Jul 2014 14:48:51 GMT

hi ,

post your sample file

Re: Current year as default selection

sasikanth — Wed, 16 Jul 2014 14:51:32 GMT

Intead max overthere

use

maxstring([Budget Year Description])

Re: Current year as default selection

alexandros17 — Wed, 16 Jul 2014 14:59:16 GMT

IN the field write only

[Budget Year Description]

Re: Current year as default selection

Wed, 16 Jul 2014 15:28:28 GMT

Hi Alessandro and Sasikanth, thanks for your help. I got it working using:

Field: [Budget Year Description]

Search String: =maxstring([Budget Year Description])

It also worked with Budget Year ID.

Thanks again.