topic Dimension with section access? in QlikView https://community.qlik.com/t5/QlikView/Dimension-with-section-access/m-p/638597#M234066 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I have three tables as below:</P><P><IMG alt="test.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/59125_test.jpg" /></P><P>And the section access as below:</P><P><IMG alt="test1.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/59147_test1.jpg" /></P><P></P><P>What I want is something like below when I login as USER1:</P><P><IMG alt="test2.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/59148_test2.jpg" /></P><P>Bu after I login as USER1 it shows me:</P><P><IMG alt="test3.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/59149_test3.jpg" /></P><P></P><P>And I already tried the Dimension tab 'Suppress When Value Is Null','Show All Values' and Presentation tab 'Suppress Zero-Values', seems not work, anyone can help?</P><P>Thank you very much.</P></BODY></HTML> Mon, 19 May 2014 17:52:19 GMT 2014-05-19T17:52:19Z Dimension with section access? https://community.qlik.com/t5/QlikView/Dimension-with-section-access/m-p/638597#M234066 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I have three tables as below:</P><P><IMG alt="test.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/59125_test.jpg" /></P><P>And the section access as below:</P><P><IMG alt="test1.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/59147_test1.jpg" /></P><P></P><P>What I want is something like below when I login as USER1:</P><P><IMG alt="test2.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/59148_test2.jpg" /></P><P>Bu after I login as USER1 it shows me:</P><P><IMG alt="test3.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/59149_test3.jpg" /></P><P></P><P>And I already tried the Dimension tab 'Suppress When Value Is Null','Show All Values' and Presentation tab 'Suppress Zero-Values', seems not work, anyone can help?</P><P>Thank you very much.</P></BODY></HTML> Mon, 19 May 2014 17:52:19 GMT https://community.qlik.com/t5/QlikView/Dimension-with-section-access/m-p/638597#M234066 2014-05-19T17:52:19Z Re: Dimension with section access? https://community.qlik.com/t5/QlikView/Dimension-with-section-access/m-p/638598#M234067 <HTML><HEAD></HEAD><BODY><P>That is not how section access works. If you log on as USER1, then the only possible name is Donna, and the only possible Items are A, B, C and D. <EM style="text-decoration: underline;">E doesn't exist for Donna.</EM> Strictly speaking, Donna isn't even allowed to know that there exists a value E.</P><P></P><P>HIC</P></BODY></HTML> Mon, 19 May 2014 18:07:05 GMT https://community.qlik.com/t5/QlikView/Dimension-with-section-access/m-p/638598#M234067 hic 2014-05-19T18:07:05Z