topic Re: How to Display Column values to row in Straight table in QlikView https://community.qlik.com/t5/QlikView/How-to-Display-Column-values-to-row-in-Straight-table/m-p/1026535#M927072 <HTML><HEAD></HEAD><BODY><P>Use <STRONG>Team</STRONG> as dimension and <STRONG>Concat(Dept, ';')</STRONG> as expression</P></BODY></HTML> Thu, 31 Mar 2016 13:17:12 GMT sunny_talwar 2016-03-31T13:17:12Z How to Display Column values to row in Straight table https://community.qlik.com/t5/QlikView/How-to-Display-Column-values-to-row-in-Straight-table/m-p/1026533#M927070 <HTML><HEAD></HEAD><BODY><P>Hi I have data like</P><TABLE border="1" class="jiveBorder" height="230" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 336px; height: 231.64px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Team</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Dept</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>Aab IT</P></TD><TD>Other</TD></TR><TR><TD style="padding: 2px;">Aab IT</TD><TD style="padding: 2px;"><P>IT</P></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">Ssms</TD><TD style="padding: 2px;"><P>Normal</P></TD></TR><TR><TD style="padding: 2px;">Abbms</TD><TD style="padding: 2px;">None</TD></TR></TBODY></TABLE><P></P><P></P><P> here when I select&nbsp; filter Team(<STRONG style="font-size: 12pt;">Aab IT)</STRONG> in my straight table it is showing Other and IT in two rows, But I want to show it in a single row</P><P>like <SPAN style="font-size: 12pt;"><STRONG>'Other;IT'.</STRONG></SPAN></P><P></P><P>how can I show it</P><P></P><P></P><P>Please help me.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-Display-Column-values-to-row-in-Straight-table/m-p/1026533#M927070 2020-11-25T16:16:04Z Re: How to Display Column values to row in Straight table https://community.qlik.com/t5/QlikView/How-to-Display-Column-values-to-row-in-Straight-table/m-p/1026534#M927071 <HTML><HEAD></HEAD><BODY><P>I presume your expression I currently "dept", in which case, change it to <SPAN style="color: #0000ff; font-size: 8pt;">Concat</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Dept</SPAN><SPAN style="font-size: 8pt;">,';') </SPAN></P><P></P><P>Andy</P></BODY></HTML> Thu, 31 Mar 2016 13:14:59 GMT https://community.qlik.com/t5/QlikView/How-to-Display-Column-values-to-row-in-Straight-table/m-p/1026534#M927071 awhitfield 2016-03-31T13:14:59Z Re: How to Display Column values to row in Straight table https://community.qlik.com/t5/QlikView/How-to-Display-Column-values-to-row-in-Straight-table/m-p/1026535#M927072 <HTML><HEAD></HEAD><BODY><P>Use <STRONG>Team</STRONG> as dimension and <STRONG>Concat(Dept, ';')</STRONG> as expression</P></BODY></HTML> Thu, 31 Mar 2016 13:17:12 GMT https://community.qlik.com/t5/QlikView/How-to-Display-Column-values-to-row-in-Straight-table/m-p/1026535#M927072 sunny_talwar 2016-03-31T13:17:12Z