topic Re: Always One Selected in QlikView

Always One Selected

wonkymeister — Thu, 18 Feb 2016 15:42:49 GMT

Afternoon all

having an issue with an selector, in that once it is loaded onto the server and viewed via the access point the option "Always One Selected" is ON.

I don't want/ intend this to be the case, i want the user to have the option of no values being selected.

if i open the QVW, the selector has no fields selected. Then if i copy the QVW up to the server, then open the QVW again to check, the selector still has no values selected (as you'd expect). But if i then open the app via the access point to view the selector - a field is selected and cannot be deselected.

how do i go about removing this "forced field" issue - and why is it happening?

This is a stand alone dataset (no joins).

11.2, SR12

thanks in advance.

Re: Always One Selected

sunny_talwar — Thu, 18 Feb 2016 15:45:48 GMT

The only thing I can think of is if the copy on the server has changed the setting. Grab the version on the server and check if 'Always One Value Selected' is unchecked or not. Or simply replace the copy on server with the one you have on your desktop.

Re: Always One Selected

marcus_sommer — Thu, 18 Feb 2016 15:47:17 GMT

Is there any section access implemented?

- Marcus

Re: Always One Selected

wonkymeister — Thu, 18 Feb 2016 15:48:24 GMT

Hi,

cheers for the reply. Ive tried amending the server copy as well as replacing the server copy with my local copy.

its bizzare.

i've got the server copy open now - and the selector has Always One Selected unchecked. But when viewing with IE via the access point, the selector is stuck on always one selected!

driving me crazy!

Re: Always One Selected

wonkymeister — Thu, 18 Feb 2016 15:50:27 GMT

yep - Section Access is used but doesn't involve this particular field

Re: Always One Selected

marcus_sommer — Thu, 18 Feb 2016 15:56:23 GMT

Are you sure that the associations from your section access to these field provide more then these single dimension-value for this particular user? Maybe you could try it with a user which has more rights or whole access.

- Marcus

Re: Always One Selected

wonkymeister — Thu, 18 Feb 2016 16:00:17 GMT

there's no association to the field in question - its just basic section access

Re: Always One Selected

gsbeaton — Thu, 18 Feb 2016 16:30:35 GMT

Hi There,

Sorry, I don't have any definite answers, sounds like this one will just require good old fasioned forensic investigation. Here are a few things to try though:

Go to QMC > Documents tab > User Documents panel > Server > Server Objects Panel. Review server objects for your user. Consider deleting any that are there.
In Access Point, click the 'Remove Last Document State' button.
In the QlikView application, go to Settings > Document Properties > Opening tab. Ensure 'Initial Data reduction Based on Section Access' is checked, rather than 'Initial Selection based on section access'.

Hope this helps. Do post the solution once you've found out what it was.

Kind regards

George

Re: Always One Selected

wonkymeister — Fri, 19 Feb 2016 09:16:06 GMT

George you're a legend!

Remove Last Document State did the trick (they're are no server objects to remove and the SA is set correctly)

i didn't even know what that button did - is it akin to clearing the cache for that app?

i need some server training!

Re: Always One Selected

gsbeaton — Thu, 03 Mar 2016 19:16:09 GMT

Hi Wonky,

Sorry I didn't reply to this sooner. The 'Remove Last Document State' purely resets your version of the document to the QVW version on the server, ie, the default state. So if you've moved objects around, made selection etc, all of these will be cleared and you'll be back to the start again.

Hope that helps

George