topic How to recovery a lost value from section access table (with partial reload) in QlikView https://community.qlik.com/t5/QlikView/How-to-recovery-a-lost-value-from-section-access-table-with/m-p/1245515#M395019 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have a problem related to section access and partial reload.</P><P>I follow these steps:</P><P>1) Full Reload of a application with section access where users are associated to one or more company.</P><P>The list of company was:<STRONG> </STRONG>A, B, C.</P><P>2) Then I wanted to freeze data in the application apart from section access, in order to enter new users or eliminate old users: I Partial Reload the application every night, with the word "Replace" over the section access table.</P><P>3) The list of company changed in the DB table: company C was deleted and appeared company D and<SPAN style="text-decoration: underline;"> I did a mistake</SPAN>: I remove from section access table records with Company C, even if in the freezed application users should be able to see it again!!</P><P>4) So I restore the old section access table adding the records with company C but,<SPAN style="text-decoration: underline;"> users can't see it anymore!</SPAN></P><P></P><P>Is there a solution to this problem?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 29 Nov 2016 15:30:54 GMT Anonymous 2016-11-29T15:30:54Z How to recovery a lost value from section access table (with partial reload) https://community.qlik.com/t5/QlikView/How-to-recovery-a-lost-value-from-section-access-table-with/m-p/1245515#M395019 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have a problem related to section access and partial reload.</P><P>I follow these steps:</P><P>1) Full Reload of a application with section access where users are associated to one or more company.</P><P>The list of company was:<STRONG> </STRONG>A, B, C.</P><P>2) Then I wanted to freeze data in the application apart from section access, in order to enter new users or eliminate old users: I Partial Reload the application every night, with the word "Replace" over the section access table.</P><P>3) The list of company changed in the DB table: company C was deleted and appeared company D and<SPAN style="text-decoration: underline;"> I did a mistake</SPAN>: I remove from section access table records with Company C, even if in the freezed application users should be able to see it again!!</P><P>4) So I restore the old section access table adding the records with company C but,<SPAN style="text-decoration: underline;"> users can't see it anymore!</SPAN></P><P></P><P>Is there a solution to this problem?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 29 Nov 2016 15:30:54 GMT https://community.qlik.com/t5/QlikView/How-to-recovery-a-lost-value-from-section-access-table-with/m-p/1245515#M395019 Anonymous 2016-11-29T15:30:54Z Re: How to recovery a lost value from section access table (with partial reload) https://community.qlik.com/t5/QlikView/How-to-recovery-a-lost-value-from-section-access-table-with/m-p/1245516#M395020 <HTML><HEAD></HEAD><BODY><P>You'll have to do a full reload to rebuilt the section access table.</P></BODY></HTML> Tue, 29 Nov 2016 16:45:49 GMT https://community.qlik.com/t5/QlikView/How-to-recovery-a-lost-value-from-section-access-table-with/m-p/1245516#M395020 Gysbert_Wassenaar 2016-11-29T16:45:49Z Re: How to recovery a lost value from section access table (with partial reload) https://community.qlik.com/t5/QlikView/How-to-recovery-a-lost-value-from-section-access-table-with/m-p/1245517#M395021 <HTML><HEAD></HEAD><BODY><P>Ok, thanks, but what is the reason of this behaviour?</P><P>I suppose that the data model is complete with the old company cause of the partial reload...</P><P>Why isn't it possible to see again it?</P></BODY></HTML> Thu, 01 Dec 2016 11:30:14 GMT https://community.qlik.com/t5/QlikView/How-to-recovery-a-lost-value-from-section-access-table-with/m-p/1245517#M395021 Anonymous 2016-12-01T11:30:14Z Re: How to recovery a lost value from section access table (with partial reload) https://community.qlik.com/t5/QlikView/How-to-recovery-a-lost-value-from-section-access-table-with/m-p/1245518#M395022 <HTML><HEAD></HEAD><BODY><P>Sorry, but with the partial reload I change profiles and I add/delete users... wtihout changing all data in data model... so I think It works.</P><P>I just notice this behaviour.</P></BODY></HTML> Thu, 01 Dec 2016 13:07:34 GMT https://community.qlik.com/t5/QlikView/How-to-recovery-a-lost-value-from-section-access-table-with/m-p/1245518#M395022 Anonymous 2016-12-01T13:07:34Z Re: How to recovery a lost value from section access table (with partial reload) https://community.qlik.com/t5/QlikView/How-to-recovery-a-lost-value-from-section-access-table-with/m-p/1245519#M395023 <HTML><HEAD></HEAD><BODY><P>Are you sure? I use partial reload for section access and it works.</P></BODY></HTML> Mon, 05 Dec 2016 14:51:30 GMT https://community.qlik.com/t5/QlikView/How-to-recovery-a-lost-value-from-section-access-table-with/m-p/1245519#M395023 Anonymous 2016-12-05T14:51:30Z