topic Re: How to do column into row in dashboard in QlikView https://community.qlik.com/t5/QlikView/How-to-do-column-into-row-in-dashboard/m-p/120522#M757891 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/200397">How to convert columns to rows in the data load editor?</A></P><P></P><P>This thread offers some cool information</P></BODY></HTML> Fri, 24 Aug 2018 12:59:20 GMT hamza99a 2018-08-24T12:59:20Z How to do column into row in dashboard https://community.qlik.com/t5/QlikView/How-to-do-column-into-row-in-dashboard/m-p/120518#M757887 <HTML><HEAD></HEAD><BODY><P>Hi, After getting data from database. How to convert column into row in straight table or pivot table.</P><P></P><P>&nbsp; My straight table. </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 256px;"><TBODY><TR><TD height="17" style="vertical-align: baseline;" width="64">DATE</TD><TD class="xl63" width="96">CODE</TD><TD class="xl63" style="border-left: none;" width="96">Sum of Weight</TD></TR><TR><TD class="xl67" height="17">05-03-2018</TD><TD class="xl66" style="border-top: none; border-left: none;">BR|0215</TD><TD class="xl68" style="border-top: none; border-left: none;">4441.7</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">05-03-2018</TD><TD class="xl66" style="border-top: none; border-left: none;">BR|0216</TD><TD class="xl68" style="border-top: none; border-left: none;">10379</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">05-03-2018</TD><TD class="xl66" style="border-top: none; border-left: none;">BR|0226</TD><TD class="xl68" style="border-top: none; border-left: none;">12186</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">05-03-2018</TD><TD class="xl66" style="border-top: none; border-left: none;">BR|0225</TD><TD class="xl68" style="border-top: none; border-left: none;">16012.7</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">06-03-2018</TD><TD class="xl66" style="border-top: none; border-left: none;">BR|0225</TD><TD class="xl68" style="border-top: none; border-left: none;">9450.5</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">06-03-2018</TD><TD class="xl66" style="border-top: none; border-left: none;">BR|0226</TD><TD class="xl68" style="border-top: none; border-left: none;">12458.3</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">06-03-2018</TD><TD class="xl66" style="border-top: none; border-left: none;">BR|0215</TD><TD class="xl68" style="border-top: none; border-left: none;">12552.1</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">06-03-2018</TD><TD class="xl66" style="border-top: none; border-left: none;">BR|0216</TD><TD class="xl68" style="border-top: none; border-left: none;">13424.1</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">06-03-2018</TD><TD class="xl66" style="border-top: none; border-left: none;">BR|6057</TD><TD class="xl68" style="border-top: none; border-left: none;">86185.2</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">07-03-2018</TD><TD class="xl66" style="border-top: none; border-left: none;">BR|0216</TD><TD class="xl68" style="border-top: none; border-left: none;">12156.1</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">07-03-2018</TD><TD class="xl66" style="border-top: none; border-left: none;">BR|0215</TD><TD class="xl68" style="border-top: none; border-left: none;">13467.3</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">07-03-2018</TD><TD class="xl66" style="border-top: none; border-left: none;">BR|0226</TD><TD class="xl68" style="border-top: none; border-left: none;">14249.8</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">07-03-2018</TD><TD class="xl66" style="border-top: none; border-left: none;">BR|0225</TD><TD class="xl68" style="border-top: none; border-left: none;">16239.2</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">07-03-2018</TD><TD class="xl66" style="border-top: none; border-left: none;">BR|6085</TD><TD class="xl68" style="border-top: none; border-left: none;">60265.5</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">08-03-2018</TD><TD class="xl66" style="border-top: none; border-left: none;">BR|0226</TD><TD class="xl68" style="border-top: none; border-left: none;">13822.5</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">08-03-2018</TD><TD class="xl66" style="border-top: none; border-left: none;">BR|0216</TD><TD class="xl68" style="border-top: none; border-left: none;">14569</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">08-03-2018</TD><TD class="xl66" style="border-top: none; border-left: none;">BR|0215</TD><TD class="xl68" style="border-top: none; border-left: none;">16104.9</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">08-03-2018</TD><TD class="xl66" style="border-top: none; border-left: none;">BR|0225</TD><TD class="xl68" style="border-top: none; border-left: none;">21236.1</TD></TR><TR><TD class="xl64" style="border-top: none;">Total</TD><TD class="xl65" style="border-top: none;"></TD><TD><SPAN style="font-size: 13.3333px;">1159901</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>Requirement Table<SPAN style="font-size: 10pt;">&nbsp;&nbsp; </SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="125" style="width: 564px; height: 127px;"><TBODY><TR><TD height="20" width="89">Date</TD><TD class="xl66" width="74">BR|0215</TD><TD class="xl66" style="border-left: none;" width="64">BR|0216</TD><TD class="xl66" style="border-left: none;" width="64">BR|0226</TD><TD class="xl66" style="border-left: none;" width="64">BR|0225</TD><TD class="xl66" style="border-left: none;" width="64">BR|6057</TD><TD class="xl66" style="border-left: none;" width="64">BR|6085</TD><TD class="xl68" width="64">TOTAL</TD></TR><TR><TD class="xl67" height="20">05-03-2018</TD><TD class="xl65" style="border-top: none; border-left: none;">4441.7</TD><TD class="xl65" style="border-top: none; border-left: none;">10379</TD><TD class="xl65" style="border-top: none; border-left: none;">12186</TD><TD class="xl65" style="border-top: none; border-left: none;">16012.7</TD><TD align="right"></TD><TD></TD><TD><SPAN style="font-size: 13.3333px; text-align: -webkit-right;">43019.4</SPAN></TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">06-03-2018</TD><TD class="xl65" style="border-top: none; border-left: none;">12552.1</TD><TD class="xl65" style="border-top: none; border-left: none;">13424.1</TD><TD class="xl65" style="border-top: none; border-left: none;">12458.3</TD><TD class="xl65" style="border-top: none; border-left: none;">9450.5</TD><TD class="xl65" style="border-left: none;">86185.2</TD><TD align="right"></TD><TD>134070.2</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">07-03-2018</TD><TD class="xl65" style="border-top: none; border-left: none;">13467.3</TD><TD class="xl65" style="border-top: none; border-left: none;">12156.1</TD><TD class="xl65" style="border-top: none; border-left: none;">14249.8</TD><TD class="xl65" style="border-top: none; border-left: none;">16239.2</TD><TD class="xl65"></TD><TD align="right">60265.2</TD><TD><SPAN style="font-size: 13.3333px; text-align: -webkit-right;">116377.9</SPAN></TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">08-03-2018</TD><TD class="xl65" style="border-top: none; border-left: none;">16104.9</TD><TD class="xl65" style="border-top: none; border-left: none;">14569</TD><TD class="xl65" style="border-top: none; border-left: none;">13822.5</TD><TD class="xl65" style="border-top: none; border-left: none;">21236.1</TD><TD align="right"></TD><TD></TD><TD><SPAN style="font-size: 13.3333px; text-align: -webkit-right;">65732.5</SPAN></TD></TR></TBODY></TABLE><P></P><P>Plz help me out.</P><P></P><P></P><P>T<SPAN style="font-size: 10pt;">hanks,</SPAN></P><P>debabrata</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-do-column-into-row-in-dashboard/m-p/120518#M757887 debabrata_sahoo 2020-11-25T16:16:04Z Re: How to do column into row in dashboard https://community.qlik.com/t5/QlikView/How-to-do-column-into-row-in-dashboard/m-p/120519#M757888 <HTML><HEAD></HEAD><BODY><P>hello debabrata,</P><P></P><P>I have used Vizlib extensions. They have powerful straight tables and pivot tables that are much more customizeable than the normal Qlik tables. I definitely would check them out!</P><P><A href="https://www.vizlib.com/#downloadlibrary" title="https://www.vizlib.com/#downloadlibrary">Vizlib | Qlik Sense Extension Library</A></P><P>Hope this helps,</P><P>Hamza</P></BODY></HTML> Fri, 24 Aug 2018 12:43:54 GMT https://community.qlik.com/t5/QlikView/How-to-do-column-into-row-in-dashboard/m-p/120519#M757888 hamza99a 2018-08-24T12:43:54Z Re: How to do column into row in dashboard https://community.qlik.com/t5/QlikView/How-to-do-column-into-row-in-dashboard/m-p/120520#M757889 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You need to use a pivot table for that. Then <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">drag the <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">CODE </SPAN>dimension of the pivot table to the right over the Expressions.</SPAN></P></BODY></HTML> Fri, 24 Aug 2018 12:47:18 GMT https://community.qlik.com/t5/QlikView/How-to-do-column-into-row-in-dashboard/m-p/120520#M757889 jaumecf23 2018-08-24T12:47:18Z Re: How to do column into row in dashboard https://community.qlik.com/t5/QlikView/How-to-do-column-into-row-in-dashboard/m-p/120521#M757890 <HTML><HEAD></HEAD><BODY><P>its for qlikview.</P></BODY></HTML> Fri, 24 Aug 2018 12:56:05 GMT https://community.qlik.com/t5/QlikView/How-to-do-column-into-row-in-dashboard/m-p/120521#M757890 debabrata_sahoo 2018-08-24T12:56:05Z Re: How to do column into row in dashboard https://community.qlik.com/t5/QlikView/How-to-do-column-into-row-in-dashboard/m-p/120522#M757891 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/200397">How to convert columns to rows in the data load editor?</A></P><P></P><P>This thread offers some cool information</P></BODY></HTML> Fri, 24 Aug 2018 12:59:20 GMT https://community.qlik.com/t5/QlikView/How-to-do-column-into-row-in-dashboard/m-p/120522#M757891 hamza99a 2018-08-24T12:59:20Z Re: How to do column into row in dashboard https://community.qlik.com/t5/QlikView/How-to-do-column-into-row-in-dashboard/m-p/120523#M757892 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Hi,<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">may be it will help you try this</SPAN></P><P><IMG alt="cap.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/211751_cap.PNG" style="height: auto;" /></P></BODY></HTML> Fri, 24 Aug 2018 13:09:02 GMT https://community.qlik.com/t5/QlikView/How-to-do-column-into-row-in-dashboard/m-p/120523#M757892 vishweshwarisun 2018-08-24T13:09:02Z Re: How to do column into row in dashboard https://community.qlik.com/t5/QlikView/How-to-do-column-into-row-in-dashboard/m-p/120524#M757893 <HTML><HEAD></HEAD><BODY><P>Pivot table:</P><P></P><P>Dimensions: DATE, CODE</P><P>Expression: Sum(Weight) as Sum of Weight.</P><P></P><P>Drag the Code dimension towards right side and leave.</P><P></P><P>Now data changes like below:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="125"><TBODY><TR><TD height="20" style="border: 0px solid black;" width="89">Date</TD><TD class="xl66" style="border: 0px solid black;" width="74">BR|0215</TD><TD class="xl66" style="border: 0px solid black; border-left: none;" width="64">BR|0216</TD><TD class="xl66" style="border: 0px solid black; border-left: none;" width="64">BR|0226</TD><TD class="xl66" style="border: 0px solid black; border-left: none;" width="64">BR|0225</TD><TD class="xl66" style="border: 0px solid black; border-left: none;" width="64">BR|6057</TD><TD class="xl66" style="border: 0px solid black; border-left: none;" width="64">BR|6085</TD><TD class="xl68" style="border: 0px solid black;" width="64">TOTAL</TD></TR><TR><TD class="xl67" height="20" style="border: 0px solid black;">05-03-2018</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">4441.7</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">10379</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">12186</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">16012.7</TD><TD align="right" style="border: 0px solid black;"></TD><TD style="border: 0px solid black;"></TD><TD style="border: 0px solid black;"><SPAN style="font-size: 13.3333px; text-align: -webkit-right;">43019.4</SPAN></TD></TR><TR><TD class="xl67" height="20" style="border: 0px solid black; border-top: none;">06-03-2018</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">12552.1</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">13424.1</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">12458.3</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">9450.5</TD><TD class="xl65" style="border: 0px solid black; border-left: none;">86185.2</TD><TD align="right" style="border: 0px solid black;"></TD><TD style="border: 0px solid black;">134070.2</TD></TR><TR><TD class="xl67" height="20" style="border: 0px solid black; border-top: none;">07-03-2018</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">13467.3</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">12156.1</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">14249.8</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">16239.2</TD><TD class="xl65" style="border: 0px solid black;"></TD><TD align="right" style="border: 0px solid black;">60265.2</TD><TD style="border: 0px solid black;"><SPAN style="font-size: 13.3333px; text-align: -webkit-right;">116377.9</SPAN></TD></TR><TR><TD class="xl67" height="20" style="border: 0px solid black; border-top: none;">08-03-2018</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">16104.9</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">14569</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">13822.5</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">21236.1</TD><TD align="right" style="border: 0px solid black;"></TD><TD style="border: 0px solid black;"></TD><TD style="border: 0px solid black;"><SPAN style="font-size: 13.3333px; text-align: -webkit-right;">5732.5</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 24 Aug 2018 16:13:50 GMT https://community.qlik.com/t5/QlikView/How-to-do-column-into-row-in-dashboard/m-p/120524#M757893 BalaBhaskar_Qlik 2018-08-24T16:13:50Z