topic Session access problems and reducing fields in QlikView https://community.qlik.com/t5/QlikView/Session-access-problems-and-reducing-fields/m-p/1163815#M898943 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Good morning everyone, I wanna ask something about session access, on below I create a table which use BIGKEY as key to reduce fields, but we dont want the key 'ALL|ALL|ALL', we try to make "where BIGKEY &lt;&gt;&nbsp; <SPAN style="font-size: 13.3333px;">'ALL|ALL|ALL'" after from sentence but it doesnt work. Later on we try to do a resident table, it works in the test case but when we try to make the resident table to section access, it doesnt work again. Can anyone explain this to me or suggest some possible solutions to me? Thanks</SPAN></P><P style="font-size: 13.3333px;"><IMG __jive_id="132739" alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/132739_Capture.JPG" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Session access problems and reducing fields https://community.qlik.com/t5/QlikView/Session-access-problems-and-reducing-fields/m-p/1163815#M898943 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Good morning everyone, I wanna ask something about session access, on below I create a table which use BIGKEY as key to reduce fields, but we dont want the key 'ALL|ALL|ALL', we try to make "where BIGKEY &lt;&gt;&nbsp; <SPAN style="font-size: 13.3333px;">'ALL|ALL|ALL'" after from sentence but it doesnt work. Later on we try to do a resident table, it works in the test case but when we try to make the resident table to section access, it doesnt work again. Can anyone explain this to me or suggest some possible solutions to me? Thanks</SPAN></P><P style="font-size: 13.3333px;"><IMG __jive_id="132739" alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/132739_Capture.JPG" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Session-access-problems-and-reducing-fields/m-p/1163815#M898943 2020-11-25T16:16:04Z