topic Re: qv app security in QlikView https://community.qlik.com/t5/QlikView/qv-app-security/m-p/1068202#M357028 <HTML><HEAD></HEAD><BODY><P>The reason is that there are some missing links between your facts and your section access. This meant not all of sales has a valid association to your section access matching. You need to make sure that your data-quality is 100 percent or you need to fill these missing links with real values like 'NULL' or 'MISSING' and associate them also within your section access: <A href="https://community.qlik.com/docs/DOC-3155">NULL handling in QlikView</A></P><P></P><P>- Marcus</P></BODY></HTML> Mon, 14 Mar 2016 16:12:50 GMT marcus_sommer 2016-03-14T16:12:50Z qv app security https://community.qlik.com/t5/QlikView/qv-app-security/m-p/1068201#M357027 <HTML><HEAD></HEAD><BODY><P>hello all,</P><P></P><P>i have a sales model and an excell file (security) that holds sales managers names and related departments,</P><P>when sales managers accses the model they can see only their related department sales data.</P><P></P><P>all is working good and stable,</P><P>the only problem is the data reduce when nulls dissapear from the model, i guess not related with any depatment. </P><P>global sales manager (opened for all departments) canot see the correct total.</P><P></P><P>when reloading the model it comes back - save and open and its gone ..</P><P>- unchecked the reduce data from security tab.</P><P>- 'None' compression in save tab</P><P></P><P>any recomendetion for solving this issue or other security options?</P><P></P><P>advenced thanks,</P></BODY></HTML> Mon, 14 Mar 2016 15:52:19 GMT https://community.qlik.com/t5/QlikView/qv-app-security/m-p/1068201#M357027 ilanbaruch 2016-03-14T15:52:19Z Re: qv app security https://community.qlik.com/t5/QlikView/qv-app-security/m-p/1068202#M357028 <HTML><HEAD></HEAD><BODY><P>The reason is that there are some missing links between your facts and your section access. This meant not all of sales has a valid association to your section access matching. You need to make sure that your data-quality is 100 percent or you need to fill these missing links with real values like 'NULL' or 'MISSING' and associate them also within your section access: <A href="https://community.qlik.com/docs/DOC-3155">NULL handling in QlikView</A></P><P></P><P>- Marcus</P></BODY></HTML> Mon, 14 Mar 2016 16:12:50 GMT https://community.qlik.com/t5/QlikView/qv-app-security/m-p/1068202#M357028 marcus_sommer 2016-03-14T16:12:50Z