Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cannot clear selected value

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.

Labels (1)
26 Replies
Not applicable
Author

Piet,

I will gladly go back and update the comments. Everyone has been very helpful and patient. I do have one thing that is still confusing me. I saved the new QVW, logged in and the values were not selected. I wanted to give the newly save document the same new as the old document so the users would not see any disruption. However, when I do that and login, the values are present again, Again, please excuse my ignorance, but I’m still learning this tool.

Gerald

stigchel
Partner - Master
Partner - Master

Great to be of help, now regarding your question, I'm not sure if I understand you, what do you mean by 'the same new as the old document'? Where are you logging in (qvw, accesspoint) and what are the steps in sequential order that you took?

Bill_Britt
Former Employee
Former Employee

HI,

Take a look at the attached document. Maybe this will help you. If I login as user A will see all the data. If I login as B I will only see 2015. With section access you can limit and restrict what a users has access to.

Section Access;
LOAD * INLINE [
    ACCESS, USERID, DATA
    ADMIN, A, *
    USER, B, 1
    USER, C, 2
    USER, D, 3
];
Section Application;

LOAD * INLINE [
    DATA, YEAR
    1, 2015
    2, 2014
    3, 2013
];

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Not applicable
Author

So I unchecked the box and did a save as to create a new document. When I logged into the access point I could see the original QVW (BI-ADTRAV)and the newly saved QVW (BI-ADTRAV1). When I access the newly save QVW (BI-ADTRAV1) no values are selected and the everything as I expect. I attempted to do a save as on BI-ADTRAV1 and save it as BI-ADTRAV thus overwriting the previous QVW. However, when I log into the access point and look at BI-ADTRAV, the value is again selected. Hope that all made sense.

Not applicable
Author

Thanks Bill. That is very helpful. As I review my section access, I don’t see that we are limiting any access for any users. This is internal data so everyone should be able to see. We don’t give our external customers access to this document at all.

stigchel
Partner - Master
Partner - Master

It may take some time (10 min or so) before the server updates...

Anonymous
Not applicable
Author

Maybe you don't need section access at all in this case?  Or use section access without data reduction.