topic Re: Default Selections in QlikView

Default Selections

Wed, 06 Jun 2012 04:12:01 GMT

Hello All,

I have Year and Month listbox on my Reports.

When I open the report, I want to show default Year and Month as current year and month.

I did do all the required settings as below:

1. Create 2 variables for year and Month.

2. On On-Open trigger set the action for "select in field" with the value of the variable created in step1.

Then I close the document and reopen it, it shows the default selected year and month(works fine for desktop appl).

Then I access the same document from access point, but it does not show the default selections.

Also this is working perfectly for some reports,

but for some reports, not working.

So please anyone put some light on it, as why its working for 1 report and not for other report?

Default Selections

rwunderlich — Wed, 06 Jun 2012 04:50:53 GMT

I'm not sure why your technique is not working, but the variables should be unnecessary. You can set your select in field values to an expression like:

=year(today(1))

-Rob

http://robwunderlich.com

Re: Default Selections

Wed, 13 Jun 2012 04:12:37 GMT

Hello Rob,

I did try by directly setting as Year(today(1)),

But viewing through accesspoint it is not working, it is not showing default selections.

what might be left because of which it is just working on desktop QV and not from access point.

Re: Default Selections

rwunderlich — Wed, 13 Jun 2012 05:11:24 GMT

Not sure what may be the problem. You are using an "=" in front of your selection expression, right?

-Rob

Re: Default Selections

Thu, 14 Jun 2012 03:49:33 GMT

Hello Rob,

resolved the issue.

I created a function in edit module and did call that from 'On Open' action

and that is working.

Thanks for your help.