topic Dimensionality issue in QlikView https://community.qlik.com/t5/QlikView/Dimensionality-issue/m-p/9390#M1421 <HTML><HEAD></HEAD><BODY><P>All, help needed on Dimensionality in pivot table</P><P>cat1,cat2,ID,Orders</P><P>A1,A2,11,Executive</P><P>A1,A2,12,Nonexecutive</P><P>A1,A2,13,Executive,</P><P>B1,B2,11,NonExcecutive</P><P>C1,C2,12,Executive</P><P>need the </P><P>Dimensionality 3--Categories for Orders with Executive values as Yes and for nonexecutive as No </P><P>--for Dimensionlaity 2 -- it should display the No even if there is one No for Dimensionality 3</P><P>same for Dimensionality 1</P><P></P><P>Expected:</P><P>Cat1&nbsp; Cat2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Orders</P><P>A1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; No</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; No</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yes</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; No</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yes</P></BODY></HTML> Mon, 26 Feb 2018 07:31:13 GMT Anonymous 2018-02-26T07:31:13Z Dimensionality issue https://community.qlik.com/t5/QlikView/Dimensionality-issue/m-p/9390#M1421 <HTML><HEAD></HEAD><BODY><P>All, help needed on Dimensionality in pivot table</P><P>cat1,cat2,ID,Orders</P><P>A1,A2,11,Executive</P><P>A1,A2,12,Nonexecutive</P><P>A1,A2,13,Executive,</P><P>B1,B2,11,NonExcecutive</P><P>C1,C2,12,Executive</P><P>need the </P><P>Dimensionality 3--Categories for Orders with Executive values as Yes and for nonexecutive as No </P><P>--for Dimensionlaity 2 -- it should display the No even if there is one No for Dimensionality 3</P><P>same for Dimensionality 1</P><P></P><P>Expected:</P><P>Cat1&nbsp; Cat2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Orders</P><P>A1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; No</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; No</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yes</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; No</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yes</P></BODY></HTML> Mon, 26 Feb 2018 07:31:13 GMT https://community.qlik.com/t5/QlikView/Dimensionality-issue/m-p/9390#M1421 Anonymous 2018-02-26T07:31:13Z Re: Dimensionality issue https://community.qlik.com/t5/QlikView/Dimensionality-issue/m-p/9391#M1422 <HTML><HEAD></HEAD><BODY><P>something like this ?</P><P></P><P><IMG alt="Orders.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/194523_Orders.png" style="height: 349px; width: 620px;" /></P></BODY></HTML> Mon, 26 Feb 2018 07:47:02 GMT https://community.qlik.com/t5/QlikView/Dimensionality-issue/m-p/9391#M1422 kakani87 2018-02-26T07:47:02Z Re: Dimensionality issue https://community.qlik.com/t5/QlikView/Dimensionality-issue/m-p/9392#M1423 <HTML><HEAD></HEAD><BODY><P>yes Kishore but with indent mode</P></BODY></HTML> Mon, 26 Feb 2018 07:54:05 GMT https://community.qlik.com/t5/QlikView/Dimensionality-issue/m-p/9392#M1423 Anonymous 2018-02-26T07:54:05Z Re: Dimensionality issue https://community.qlik.com/t5/QlikView/Dimensionality-issue/m-p/9393#M1424 <HTML><HEAD></HEAD><BODY><P>Can you explain&nbsp; exactly Indent mode </P></BODY></HTML> Mon, 26 Feb 2018 08:07:49 GMT https://community.qlik.com/t5/QlikView/Dimensionality-issue/m-p/9393#M1424 kakani87 2018-02-26T08:07:49Z Re: Dimensionality issue https://community.qlik.com/t5/QlikView/Dimensionality-issue/m-p/9394#M1425 <HTML><HEAD></HEAD><BODY><P>Any sample Screen shot</P></BODY></HTML> Mon, 26 Feb 2018 08:08:35 GMT https://community.qlik.com/t5/QlikView/Dimensionality-issue/m-p/9394#M1425 kakani87 2018-02-26T08:08:35Z Re: Dimensionality issue https://community.qlik.com/t5/QlikView/Dimensionality-issue/m-p/9395#M1426 <HTML><HEAD></HEAD><BODY><P>please check indent mode under Style tab</P></BODY></HTML> Mon, 26 Feb 2018 08:16:11 GMT https://community.qlik.com/t5/QlikView/Dimensionality-issue/m-p/9395#M1426 Anonymous 2018-02-26T08:16:11Z Re: Dimensionality issue https://community.qlik.com/t5/QlikView/Dimensionality-issue/m-p/9396#M1427 <HTML><HEAD></HEAD><BODY><P><IMG alt="Indentmode.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/194528_Indentmode.png" style="height: 349px; width: 620px;" /></P><P>Yes I understood</P><P>Check&nbsp; partial sum in Presentation tab</P></BODY></HTML> Mon, 26 Feb 2018 08:19:53 GMT https://community.qlik.com/t5/QlikView/Dimensionality-issue/m-p/9396#M1427 kakani87 2018-02-26T08:19:53Z