topic Re: Is it posable? in QlikView https://community.qlik.com/t5/QlikView/Is-it-posable/m-p/1460701#M793621 <HTML><HEAD></HEAD><BODY><P>Yes, just use concatenate with pivot table</P><P><STRONG>Concat(City,',')</STRONG></P><P>or</P><P><STRONG>=aggr(Concat(City,','),Day) // if u r adding dimension as Calculated dimension</STRONG></P><P><STRONG><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/189315_Capture.JPG" style="height: 366px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Mon, 08 Jan 2018 14:59:05 GMT devarasu07 2018-01-08T14:59:05Z Is it posable? https://community.qlik.com/t5/QlikView/Is-it-posable/m-p/1460700#M793620 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have this:</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192px;"><TBODY><TR><TD height="20" width="64">Month</TD><TD width="64">Day</TD><TD width="64">City</TD></TR><TR><TD align="right" height="20">11</TD><TD align="right">22&nbsp;&nbsp;&nbsp; </TD><TD>Kaunas</TD></TR><TR><TD align="right" height="20">11</TD><TD align="right">23&nbsp;&nbsp; </TD><TD>Vilnius</TD></TR><TR><TD align="right" height="20">11</TD><TD align="right">24&nbsp;&nbsp; </TD><TD>Kaunas</TD></TR><TR><TD align="right" height="20">11</TD><TD align="right">24</TD><TD>Klaipeda</TD></TR><TR><TD align="right" height="20">11</TD><TD align="right">25</TD><TD>Kaunas</TD></TR></TBODY></TABLE><P></P><P>Need this:</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="188"><TBODY><TR><TD class="xl65" height="20" width="64"> </TD><TD class="xl65" style="border-left: none;" width="124">Mont</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Day</TD><TD class="xl66" style="border-top: none; border-left: none;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">22</TD><TD class="xl65" style="border-top: none; border-left: none;">Kaunas</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">23</TD><TD class="xl65" style="border-top: none; border-left: none;">Vilnius</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">24</TD><TD class="xl67" style="border-top: none; border-left: none;">Kaunas, Klaipeda</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">25</TD><TD class="xl65" style="border-top: none; border-left: none;">Kaunas</TD></TR></TBODY></TABLE><P></P><P>Is it posable to show few results in one cell? I want show it in PivotTable.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Is-it-posable/m-p/1460700#M793620 irmantas 2020-11-25T16:16:04Z Re: Is it posable? https://community.qlik.com/t5/QlikView/Is-it-posable/m-p/1460701#M793621 <HTML><HEAD></HEAD><BODY><P>Yes, just use concatenate with pivot table</P><P><STRONG>Concat(City,',')</STRONG></P><P>or</P><P><STRONG>=aggr(Concat(City,','),Day) // if u r adding dimension as Calculated dimension</STRONG></P><P><STRONG><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/189315_Capture.JPG" style="height: 366px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Mon, 08 Jan 2018 14:59:05 GMT https://community.qlik.com/t5/QlikView/Is-it-posable/m-p/1460701#M793621 devarasu07 2018-01-08T14:59:05Z Re: Is it posable? https://community.qlik.com/t5/QlikView/Is-it-posable/m-p/1460702#M793622 <HTML><HEAD></HEAD><BODY><P>Thank you. It's working.</P></BODY></HTML> Tue, 09 Jan 2018 06:32:32 GMT https://community.qlik.com/t5/QlikView/Is-it-posable/m-p/1460702#M793622 irmantas 2018-01-09T06:32:32Z