topic Re: Merge the data in the straight table in QlikView https://community.qlik.com/t5/QlikView/Merge-the-data-in-the-straight-table/m-p/1323441#M409726 <HTML><HEAD></HEAD><BODY><P>Yes, We can by help of static names using ValueList() function. Aren't you? </P></BODY></HTML> Tue, 18 Jul 2017 10:09:18 GMT Anil_Babu_Samineni 2017-07-18T10:09:18Z Merge the data in the straight table https://community.qlik.com/t5/QlikView/Merge-the-data-in-the-straight-table/m-p/1323440#M409725 <HTML><HEAD></HEAD><BODY><P>Hi in the straight table can we merge the data example is the below structure</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;-webkit-right&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="border: 0px; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="40" rowspan="2" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="64">ID</TD><TD class="xl63" rowspan="2" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="64">Desc</TD><TD class="xl63" colspan="2" style="padding-right: 4px; padding-left: 4px; border-top: 0 solid black; border-right: 0 solid black; border-bottom: 0 solid black; border-left: none; font-style: inherit; font-family: inherit;" width="128">Details1</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="20" style="padding-right: 4px; padding-left: 4px; border-top: none; border-right: 0 solid black; border-bottom: 0 solid black; border-left: none; font-style: inherit; font-family: inherit;">w1</TD><TD class="xl64" style="padding-right: 4px; padding-left: 4px; border-top: none; border-right: 0 solid black; border-bottom: 0 solid black; border-left: none; font-style: inherit; font-family: inherit;">w2</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD align="right" class="xl64" height="20" style="padding-right: 4px; padding-left: 4px; border-top: none; border-right: 0 solid black; border-bottom: 0 solid black; border-left: 0 solid black; font-style: inherit; font-family: inherit;">1</TD><TD class="xl64" style="padding-right: 4px; padding-left: 4px; border-top: none; border-right: 0 solid black; border-bottom: 0 solid black; border-left: none; font-style: inherit; font-family: inherit;">A</TD><TD align="right" class="xl64" style="padding-right: 4px; padding-left: 4px; border-top: none; border-right: 0 solid black; border-bottom: 0 solid black; border-left: none; font-style: inherit; font-family: inherit;">1</TD><TD align="right" class="xl64" style="padding-right: 4px; padding-left: 4px; border-top: none; border-right: 0 solid black; border-bottom: 0 solid black; border-left: none; font-style: inherit; font-family: inherit;">1</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD align="right" class="xl64" height="20" style="padding-right: 4px; padding-left: 4px; border-top: none; border-right: 0 solid black; border-bottom: 0 solid black; border-left: 0 solid black; font-style: inherit; font-family: inherit;">2</TD><TD class="xl64" style="padding-right: 4px; padding-left: 4px; border-top: none; border-right: 0 solid black; border-bottom: 0 solid black; border-left: none; font-style: inherit; font-family: inherit;">B</TD><TD align="right" class="xl65" style="padding-right: 4px; padding-left: 4px; border-top: none; border-right: 0 solid black; border-bottom: 0 solid black; border-left: none; font-style: inherit; font-family: inherit;">2</TD><TD align="right" class="xl65" style="padding-right: 4px; padding-left: 4px; border-top: none; border-right: 0 solid black; border-bottom: 0 solid black; border-left: none; font-style: inherit; font-family: inherit;">3</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD align="right" class="xl64" height="20" style="padding-right: 4px; padding-left: 4px; border-top: none; border-right: 0 solid black; border-bottom: 0 solid black; border-left: 0 solid black; font-style: inherit; font-family: inherit;">3</TD><TD class="xl64" style="padding-right: 4px; padding-left: 4px; border-top: none; border-right: 0 solid black; border-bottom: 0 solid black; border-left: none; font-style: inherit; font-family: inherit;">C</TD><TD align="right" class="xl64" style="padding-right: 4px; padding-left: 4px; border-top: none; border-right: 0 solid black; border-bottom: 0 solid black; border-left: none; font-style: inherit; font-family: inherit;">3</TD><TD align="right" class="xl64" style="padding-right: 4px; padding-left: 4px; border-top: none; border-right: 0 solid black; border-bottom: 0 solid black; border-left: none; font-style: inherit; font-family: inherit;">3</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD align="right" class="xl64" height="20" style="padding-right: 4px; padding-left: 4px; border-top: none; border-right: 0 solid black; border-bottom: 0 solid black; border-left: 0 solid black; font-style: inherit; font-family: inherit;">4</TD><TD class="xl64" style="padding-right: 4px; padding-left: 4px; border-top: none; border-right: 0 solid black; border-bottom: 0 solid black; border-left: none; font-style: inherit; font-family: inherit;">D</TD><TD align="right" class="xl64" style="padding-right: 4px; padding-left: 4px; border-top: none; border-right: 0 solid black; border-bottom: 0 solid black; border-left: none; font-style: inherit; font-family: inherit;">4</TD><TD align="right" class="xl64" style="padding-right: 4px; padding-left: 4px; border-top: none; border-right: 0 solid black; border-bottom: 0 solid black; border-left: none; font-style: inherit; font-family: inherit;">4</TD></TR></TBODY></TABLE><P></P><P></P><P>details1&nbsp; have have been mergered and show two colum as W1 and W2</P></BODY></HTML> Tue, 18 Jul 2017 06:32:48 GMT https://community.qlik.com/t5/QlikView/Merge-the-data-in-the-straight-table/m-p/1323440#M409725 manoranjan_d 2017-07-18T06:32:48Z Re: Merge the data in the straight table https://community.qlik.com/t5/QlikView/Merge-the-data-in-the-straight-table/m-p/1323441#M409726 <HTML><HEAD></HEAD><BODY><P>Yes, We can by help of static names using ValueList() function. Aren't you? </P></BODY></HTML> Tue, 18 Jul 2017 10:09:18 GMT https://community.qlik.com/t5/QlikView/Merge-the-data-in-the-straight-table/m-p/1323441#M409726 Anil_Babu_Samineni 2017-07-18T10:09:18Z Re: Merge the data in the straight table https://community.qlik.com/t5/QlikView/Merge-the-data-in-the-straight-table/m-p/1323442#M409727 <HTML><HEAD></HEAD><BODY><P>can you provide me in the qvw file</P></BODY></HTML> Tue, 18 Jul 2017 10:26:29 GMT https://community.qlik.com/t5/QlikView/Merge-the-data-in-the-straight-table/m-p/1323442#M409727 manoranjan_d 2017-07-18T10:26:29Z Re: Merge the data in the straight table https://community.qlik.com/t5/QlikView/Merge-the-data-in-the-straight-table/m-p/1323443#M409728 <HTML><HEAD></HEAD><BODY><P>What is W1 &amp; W2? </P></BODY></HTML> Tue, 18 Jul 2017 10:31:34 GMT https://community.qlik.com/t5/QlikView/Merge-the-data-in-the-straight-table/m-p/1323443#M409728 Kushal_Chawda 2017-07-18T10:31:34Z Re: Merge the data in the straight table https://community.qlik.com/t5/QlikView/Merge-the-data-in-the-straight-table/m-p/1323444#M409729 <HTML><HEAD></HEAD><BODY><P>Week1 week2</P></BODY></HTML> Tue, 18 Jul 2017 10:41:04 GMT https://community.qlik.com/t5/QlikView/Merge-the-data-in-the-straight-table/m-p/1323444#M409729 manoranjan_d 2017-07-18T10:41:04Z Re: Merge the data in the straight table https://community.qlik.com/t5/QlikView/Merge-the-data-in-the-straight-table/m-p/1323445#M409730 <HTML><HEAD></HEAD><BODY><P>is it simple number or time object?</P></BODY></HTML> Tue, 18 Jul 2017 11:00:10 GMT https://community.qlik.com/t5/QlikView/Merge-the-data-in-the-straight-table/m-p/1323445#M409730 balar025 2017-07-18T11:00:10Z Re: Merge the data in the straight table https://community.qlik.com/t5/QlikView/Merge-the-data-in-the-straight-table/m-p/1323446#M409731 <HTML><HEAD></HEAD><BODY><P>time object</P></BODY></HTML> Tue, 18 Jul 2017 11:33:54 GMT https://community.qlik.com/t5/QlikView/Merge-the-data-in-the-straight-table/m-p/1323446#M409731 manoranjan_d 2017-07-18T11:33:54Z