topic How to remove expand option in pivot table? in QlikView https://community.qlik.com/t5/QlikView/How-to-remove-expand-option-in-pivot-table/m-p/172214#M590142 <HTML><HEAD></HEAD><BODY><P>Thanks Anita...it Works <IMG alt="Smile" src="http://community.qlik.com/emoticons/emotion-1.gif" /> !!</P></BODY></HTML> Wed, 02 Dec 2009 18:42:15 GMT 2009-12-02T18:42:15Z How to remove expand option in pivot table? https://community.qlik.com/t5/QlikView/How-to-remove-expand-option-in-pivot-table/m-p/172212#M590140 <HTML><HEAD></HEAD><BODY><P></P><P></P><P>In the pivot table I want to remove collapse from third column onwards. Is there any option from where i can keep the Usernames which belong to particular account under the tree and rest should come in columns.Expanding should be there from third column onwards...</P><P>Thanks</P></BODY></HTML> Wed, 02 Dec 2009 17:25:08 GMT https://community.qlik.com/t5/QlikView/How-to-remove-expand-option-in-pivot-table/m-p/172212#M590140 2009-12-02T17:25:08Z How to remove expand option in pivot table? https://community.qlik.com/t5/QlikView/How-to-remove-expand-option-in-pivot-table/m-p/172213#M590141 <HTML><HEAD></HEAD><BODY><P>I guesse you don't want everything always fully expanded (option Presentation--always fully expand).</P><P>What you could try is to put the fields you don't want to be expandable as expression:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />= <I>fieldname</I><BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>As far as I have seen it is not possible to say to a column not to expand any further or whatsoever.</P><P>Anita</P></BODY></HTML> Wed, 02 Dec 2009 17:37:35 GMT https://community.qlik.com/t5/QlikView/How-to-remove-expand-option-in-pivot-table/m-p/172213#M590141 Anonymous 2009-12-02T17:37:35Z How to remove expand option in pivot table? https://community.qlik.com/t5/QlikView/How-to-remove-expand-option-in-pivot-table/m-p/172214#M590142 <HTML><HEAD></HEAD><BODY><P>Thanks Anita...it Works <IMG alt="Smile" src="http://community.qlik.com/emoticons/emotion-1.gif" /> !!</P></BODY></HTML> Wed, 02 Dec 2009 18:42:15 GMT https://community.qlik.com/t5/QlikView/How-to-remove-expand-option-in-pivot-table/m-p/172214#M590142 2009-12-02T18:42:15Z