topic Pivot - Indent & Expand in QlikView https://community.qlik.com/t5/QlikView/Pivot-Indent-Expand/m-p/624154#M547534 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have the following pivot:</P><P><IMG alt="Pivot-FullyExpanded.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/52865_Pivot-FullyExpanded.png" style="width: 620px; height: 84px;" /></P><P></P><P>If I enable the property [IndentMode] and disable the property [Always Fully Expanded],</P><P>- how can I get rid of the row where Node3 is null (could be Node2 as well)</P><P>- how can I prevent a collapse on dimension which are in column</P><P><IMG alt="Pivot-Indent.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/52868_Pivot-Indent.png" style="width: 620px; height: 115px;" /></P><P>My target is to have something like this:</P><P><IMG alt="Pivot-Target.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/52869_Pivot-Target.png" style="width: 620px; height: 100px;" /></P></BODY></HTML> Mon, 10 Feb 2014 03:08:27 GMT 2014-02-10T03:08:27Z Pivot - Indent & Expand https://community.qlik.com/t5/QlikView/Pivot-Indent-Expand/m-p/624154#M547534 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have the following pivot:</P><P><IMG alt="Pivot-FullyExpanded.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/52865_Pivot-FullyExpanded.png" style="width: 620px; height: 84px;" /></P><P></P><P>If I enable the property [IndentMode] and disable the property [Always Fully Expanded],</P><P>- how can I get rid of the row where Node3 is null (could be Node2 as well)</P><P>- how can I prevent a collapse on dimension which are in column</P><P><IMG alt="Pivot-Indent.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/52868_Pivot-Indent.png" style="width: 620px; height: 115px;" /></P><P>My target is to have something like this:</P><P><IMG alt="Pivot-Target.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/52869_Pivot-Target.png" style="width: 620px; height: 100px;" /></P></BODY></HTML> Mon, 10 Feb 2014 03:08:27 GMT https://community.qlik.com/t5/QlikView/Pivot-Indent-Expand/m-p/624154#M547534 2014-02-10T03:08:27Z