topic Re: Cell merge in pivot chart in QlikView https://community.qlik.com/t5/QlikView/Cell-merge-in-pivot-chart/m-p/1112554#M892233 <HTML><HEAD></HEAD><BODY><P>You can't merge pivot table cells. Qlikview is not a spreadsheet application.</P></BODY></HTML> Tue, 16 Aug 2016 10:58:47 GMT Gysbert_Wassenaar 2016-08-16T10:58:47Z Cell merge in pivot chart https://community.qlik.com/t5/QlikView/Cell-merge-in-pivot-chart/m-p/1112553#M892232 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I need to merge cells inside a pivot table, is the scenario below possible in QlikView or do I have to modify my model?</P><P></P><P>Cheers,</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/134599_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Cell-merge-in-pivot-chart/m-p/1112553#M892232 k_burata 2020-11-25T16:16:04Z Re: Cell merge in pivot chart https://community.qlik.com/t5/QlikView/Cell-merge-in-pivot-chart/m-p/1112554#M892233 <HTML><HEAD></HEAD><BODY><P>You can't merge pivot table cells. Qlikview is not a spreadsheet application.</P></BODY></HTML> Tue, 16 Aug 2016 10:58:47 GMT https://community.qlik.com/t5/QlikView/Cell-merge-in-pivot-chart/m-p/1112554#M892233 Gysbert_Wassenaar 2016-08-16T10:58:47Z Re: Cell merge in pivot chart https://community.qlik.com/t5/QlikView/Cell-merge-in-pivot-chart/m-p/1112555#M892234 <HTML><HEAD></HEAD><BODY><P>you can not merge cell</P><P>1) you can make custom format and disable border for that cells.</P><P>2) you can play with "above"/"below" functions to move numbers down and up</P></BODY></HTML> Tue, 16 Aug 2016 12:00:13 GMT https://community.qlik.com/t5/QlikView/Cell-merge-in-pivot-chart/m-p/1112555#M892234 hubertdudek 2016-08-16T12:00:13Z Re: Cell merge in pivot chart https://community.qlik.com/t5/QlikView/Cell-merge-in-pivot-chart/m-p/1112556#M892235 <HTML><HEAD></HEAD><BODY><P>How about to this?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/134964_Capture.PNG" style="height: auto;" />&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>Am I able to do this using a calculated dimension or do I do it on the script?</P><P></P><P>Thanks</P></BODY></HTML> Fri, 19 Aug 2016 03:42:42 GMT https://community.qlik.com/t5/QlikView/Cell-merge-in-pivot-chart/m-p/1112556#M892235 k_burata 2016-08-19T03:42:42Z Re: Cell merge in pivot chart https://community.qlik.com/t5/QlikView/Cell-merge-in-pivot-chart/m-p/1112557#M892236 <HTML><HEAD></HEAD><BODY><P>use function concat</P></BODY></HTML> Fri, 19 Aug 2016 08:49:00 GMT https://community.qlik.com/t5/QlikView/Cell-merge-in-pivot-chart/m-p/1112557#M892236 florentina_doga 2016-08-19T08:49:00Z Re: Cell merge in pivot chart https://community.qlik.com/t5/QlikView/Cell-merge-in-pivot-chart/m-p/1112558#M892237 <HTML><HEAD></HEAD><BODY><P>use concat(distinct employees,',') in expressions</P></BODY></HTML> Fri, 19 Aug 2016 08:55:44 GMT https://community.qlik.com/t5/QlikView/Cell-merge-in-pivot-chart/m-p/1112558#M892237 florentina_doga 2016-08-19T08:55:44Z