topic Re: Cannot clear selected value in QlikView

Cannot clear selected value

Fri, 08 May 2015 16:18:09 GMT

I have a year value that I cannot remove as a selection. I had this field set as (always one selected value). I changed that setting and I have confirmed there are no triggers set on this field. Yet, the field is still active and will not clear using clear button. Any help is greatly appreciated.

Re: Cannot clear selected value

Anonymous — Fri, 08 May 2015 16:59:07 GMT

There could be a trigger on anything else that selects in this field.

Can you upload the app?

Re: Cannot clear selected value

Fri, 08 May 2015 17:03:42 GMT

Hi Gerald,

Do also check sheet triggers also. Sometimes it might happen like, by activating sheet a select in field trigger can be placed.

Hope it helps.

BR
Susvith

Re: Cannot clear selected value

MK_QSL — Fri, 08 May 2015 17:06:02 GMT

May be one of this...

1) you have locked any field

2) you have Always one value selected for any list box

3) go to Selections tab and select set clear state

Re: Cannot clear selected value

Fri, 08 May 2015 18:55:11 GMT

Hey Michael. I thought I checked them all, but maybe I did miss something. Fairly new to Qlik so it's possible.

Re: Cannot clear selected value

Anonymous — Fri, 08 May 2015 19:10:39 GMT

Gerald, there are two problems with your document.

First, it is huge. It would be nice to upload a smaller version.

Anyway, I downloaded it - but cannot open. It requires user/password.

Re: Cannot clear selected value

Mon, 11 May 2015 11:37:22 GMT

Michael,

Thanks again for the assistance. I’m really new to the tool so I’m not sure how to really reduce the size without removing information that may be useful to you. I’m not sure why the document would be asking for credentials, but can you try admin/1 as the credentials?

Gerald

Re: Cannot clear selected value

Mon, 11 May 2015 11:53:13 GMT

If you create a new list box with same Year field, do you still see the same behavior? If Yes, then a Sheet trigger or Docment trigger involved.

Re: Cannot clear selected value

Mon, 11 May 2015 14:20:35 GMT

Angad,

Thanks for the tip. I created a new list box with that field and it indeed has the same behavior. I am perplexed since I have checked the triggers section for every single sheet within this document and there are no triggers created at all. I also double checked the “Always One Selected Value” and it is not checked. Any additional thoughts?

Gerald

Re: Cannot clear selected value

jsakalis — Mon, 11 May 2015 14:37:53 GMT

Gerald,

I don't see any year selected in the Current Selections box. But, I think the year may be influenced by one of your variables. Please check Variable Overview to see if the year field in question is being assigned a value in an incorrect manner.

Re: Cannot clear selected value

Anonymous — Mon, 11 May 2015 14:40:47 GMT

OK, I can open your app.

Don't see selections in the Year field. There are selections in a couple other fields, but they have "always one selected" checked.

Re: Cannot clear selected value

Bill_Britt — Mon, 11 May 2015 14:48:36 GMT

What field are you talking about? I don't see any selections on the year field.

Bill

Re: Cannot clear selected value

Mon, 11 May 2015 14:48:47 GMT

Thanks John. That’s the issue. I don’t see the value selected or a trigger set, but when myself and the users login the value is set and unlock & clear does not work.

Re: Cannot clear selected value

Mon, 11 May 2015 14:51:11 GMT

Bill,

It’s the Year field on the RezFan Tab. I don’t show it selected either, but when we login it’s selected and won’t clear. Very strange.

Gerald

Re: Cannot clear selected value

stigchel — Mon, 11 May 2015 14:54:01 GMT

There are no selections in year that I can see, my guess is that this has to do with section access. In the document properties\Opening tab remove the initial data reduction checkmark and save a copy of the document. Close qlikview and reopen that copy, if there are now more than one year possible then this has to do with section access reducing data

Re: Cannot clear selected value

Mon, 11 May 2015 15:02:35 GMT

Piet,

That worked. When I login the value is cleared in the newly saved version. Thanks to all for the advice and assistance.

Gerald

Re: Cannot clear selected value

Bill_Britt — Mon, 11 May 2015 15:07:29 GMT

Hi,

When you say you login are you talking about in the accesspoint?

Bill

Re: Cannot clear selected value

Bill_Britt — Mon, 11 May 2015 15:14:34 GMT

Hi,

You need to check your section access to see what might be causing the field to be checked. There maybe an issue with SA and you are not getting all the data on the reloads.

Bill

Re: Cannot clear selected value

Mon, 11 May 2015 15:15:47 GMT

Yes

Re: Cannot clear selected value

stigchel — Mon, 11 May 2015 15:21:47 GMT

Ok great, since we did not see any 'selection' (in fact it was just one possible value) with the admin account, I'm guessing you used a different account. Since section access is applied, your are working (and maybe saving) a reduced set of the data. Log in as Admin and do a reload as last action before a save.

Also if this has solved your problem could you close this thread by marking one of the answers correct? It may also be nice to mark some of the answers helpful if you thought they were. It will help others find solutions to similar problems and lets contributing members know this requires no more attention.