topic transform in QlikView https://community.qlik.com/t5/QlikView/transform/m-p/228720#M80726 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 144pt; border-collapse: collapse;" width="192"><COLGROUP><COL span="3" style="width: 48pt;" width="64" /></COLGROUP><TBODY><TR height="18" style="height: 13.5pt;"><TD class="xl27" height="18" style="width: 48pt; height: 13.5pt; background-color: transparent; border: windowtext 1pt solid;" width="64">no</TD><TD style="width: 48pt; background-color: transparent; border: #ece9d8;" width="64"></TD><TD class="xl24" style="border-right: windowtext 1pt solid; border-top: windowtext 1pt solid; border-left: windowtext 1pt solid; width: 48pt; border-bottom: #ece9d8; background-color: transparent;" width="64">required output</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl25" height="17" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: #ece9d8; height: 12.75pt; background-color: transparent;">1</TD><TD style="background-color: transparent; border: #ece9d8;"></TD><TD align="right" class="xl25" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: #ece9d8; background-color: transparent;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl25" height="17" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: #ece9d8; height: 12.75pt; background-color: transparent;">1</TD><TD style="background-color: transparent; border: #ece9d8;"></TD><TD align="right" class="xl25" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: #ece9d8; background-color: transparent;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl25" height="17" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: #ece9d8; height: 12.75pt; background-color: transparent;">2</TD><TD style="background-color: transparent; border: #ece9d8;"></TD><TD align="right" class="xl25" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: #ece9d8; background-color: transparent;">2</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl25" height="17" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: #ece9d8; height: 12.75pt; background-color: transparent;">3</TD><TD style="background-color: transparent; border: #ece9d8;"></TD><TD align="right" class="xl25" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: #ece9d8; background-color: transparent;">3</TD></TR><TR height="18" style="height: 13.5pt;"><TD align="right" class="xl26" height="18" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: windowtext 1pt solid; height: 13.5pt; background-color: transparent;">3</TD><TD style="background-color: transparent; border: #ece9d8;"></TD><TD align="right" class="xl26" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: windowtext 1pt solid; background-color: transparent;">3</TD></TR></TBODY></TABLE><P>I have a column no (as shown above) ,i want it to transform into the required output.</P><P>Regards,</P><P>Ganesh.</P><P></P><P></P></BODY></HTML> Wed, 06 Oct 2010 06:43:35 GMT Anonymous 2010-10-06T06:43:35Z transform https://community.qlik.com/t5/QlikView/transform/m-p/228720#M80726 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 144pt; border-collapse: collapse;" width="192"><COLGROUP><COL span="3" style="width: 48pt;" width="64" /></COLGROUP><TBODY><TR height="18" style="height: 13.5pt;"><TD class="xl27" height="18" style="width: 48pt; height: 13.5pt; background-color: transparent; border: windowtext 1pt solid;" width="64">no</TD><TD style="width: 48pt; background-color: transparent; border: #ece9d8;" width="64"></TD><TD class="xl24" style="border-right: windowtext 1pt solid; border-top: windowtext 1pt solid; border-left: windowtext 1pt solid; width: 48pt; border-bottom: #ece9d8; background-color: transparent;" width="64">required output</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl25" height="17" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: #ece9d8; height: 12.75pt; background-color: transparent;">1</TD><TD style="background-color: transparent; border: #ece9d8;"></TD><TD align="right" class="xl25" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: #ece9d8; background-color: transparent;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl25" height="17" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: #ece9d8; height: 12.75pt; background-color: transparent;">1</TD><TD style="background-color: transparent; border: #ece9d8;"></TD><TD align="right" class="xl25" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: #ece9d8; background-color: transparent;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl25" height="17" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: #ece9d8; height: 12.75pt; background-color: transparent;">2</TD><TD style="background-color: transparent; border: #ece9d8;"></TD><TD align="right" class="xl25" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: #ece9d8; background-color: transparent;">2</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl25" height="17" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: #ece9d8; height: 12.75pt; background-color: transparent;">3</TD><TD style="background-color: transparent; border: #ece9d8;"></TD><TD align="right" class="xl25" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: #ece9d8; background-color: transparent;">3</TD></TR><TR height="18" style="height: 13.5pt;"><TD align="right" class="xl26" height="18" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: windowtext 1pt solid; height: 13.5pt; background-color: transparent;">3</TD><TD style="background-color: transparent; border: #ece9d8;"></TD><TD align="right" class="xl26" style="border-right: windowtext 1pt solid; border-top: #ece9d8; border-left: windowtext 1pt solid; border-bottom: windowtext 1pt solid; background-color: transparent;">3</TD></TR></TBODY></TABLE><P>I have a column no (as shown above) ,i want it to transform into the required output.</P><P>Regards,</P><P>Ganesh.</P><P></P><P></P></BODY></HTML> Wed, 06 Oct 2010 06:43:35 GMT https://community.qlik.com/t5/QlikView/transform/m-p/228720#M80726 Anonymous 2010-10-06T06:43:35Z transform https://community.qlik.com/t5/QlikView/transform/m-p/228721#M80727 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width:296pt;border-collapse:collapse;" width="392"><COLGROUP><COL style="width:74pt;mso-width-source:userset;mso-width-alt:3584;mso-outline-parent:collapsed;" width="98" /><COL style="width:74pt;mso-width-source:userset;mso-width-alt:3584;mso-outline-parent:collapsed;" width="98" /><COL style="width:74pt;mso-width-source:userset;mso-width-alt:3584;mso-outline-parent:collapsed;" width="98" /><COL style="width:74pt;mso-width-source:userset;mso-width-alt:3584;mso-outline-parent:collapsed;" width="98" /></COLGROUP><TBODY><TR style="height:12.75pt;"><TD class="xl22" height="17" style="width:74pt;height:12.75pt;background-color:whitesmoke;border:gainsboro 0.5pt solid;" width="98"><STRONG>no</STRONG></TD><TD class="xl22" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro 0.5pt solid;border-left:gainsboro;width:74pt;border-bottom:gainsboro 0.5pt solid;background-color:whitesmoke;" width="98"><STRONG>A</STRONG></TD><TD class="xl22" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro 0.5pt solid;border-left:gainsboro;width:74pt;border-bottom:gainsboro 0.5pt solid;background-color:whitesmoke;" width="98"><STRONG>B</STRONG></TD><TD class="xl22" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro 0.5pt solid;border-left:gainsboro;width:74pt;border-bottom:gainsboro 0.5pt solid;background-color:whitesmoke;" width="98"><STRONG>=rowno(total)</STRONG></TD></TR><TR style="height:12.75pt;"><TD align="right" class="xl23" height="17" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro 0.5pt solid;border-bottom:gainsboro 0.5pt solid;height:12.75pt;background-color:white;">1</TD><TD class="xl23" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">x</TD><TD class="xl23" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">a</TD><TD align="right" class="xl24" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">1</TD></TR><TR style="height:12.75pt;"><TD align="right" class="xl23" height="17" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro 0.5pt solid;border-bottom:gainsboro 0.5pt solid;height:12.75pt;background-color:white;">1</TD><TD class="xl23" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">x</TD><TD class="xl23" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">b</TD><TD align="right" class="xl24" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">2</TD></TR><TR style="height:12.75pt;"><TD align="right" class="xl23" height="17" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro 0.5pt solid;border-bottom:gainsboro 0.5pt solid;height:12.75pt;background-color:white;">2</TD><TD class="xl23" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">x</TD><TD class="xl23" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">c</TD><TD align="right" class="xl24" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">3</TD></TR><TR style="height:12.75pt;"><TD align="right" class="xl23" height="17" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro 0.5pt solid;border-bottom:gainsboro 0.5pt solid;height:12.75pt;background-color:white;">3</TD><TD class="xl23" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">y</TD><TD class="xl23" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">d</TD><TD align="right" class="xl24" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">4</TD></TR><TR style="height:12.75pt;"><TD align="right" class="xl23" height="17" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro 0.5pt solid;border-bottom:gainsboro 0.5pt solid;height:12.75pt;background-color:white;">3</TD><TD class="xl23" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">y</TD><TD class="xl23" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">r</TD><TD align="right" class="xl24" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">5</TD></TR><TR style="height:12.75pt;"><TD align="right" class="xl23" height="17" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro 0.5pt solid;border-bottom:gainsboro 0.5pt solid;height:12.75pt;background-color:white;">4</TD><TD class="xl23" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">t</TD><TD class="xl23" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">t</TD><TD align="right" class="xl24" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">6</TD></TR><TR style="height:12.75pt;"><TD align="right" class="xl23" height="17" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro 0.5pt solid;border-bottom:gainsboro 0.5pt solid;height:12.75pt;background-color:white;">5</TD><TD class="xl23" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">t</TD><TD class="xl23" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">t</TD><TD align="right" class="xl24" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro;border-bottom:gainsboro 0.5pt solid;background-color:white;">7</TD></TR></TBODY></TABLE><P></P><P>the output should be as follows :</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width:74pt;border-collapse:collapse;" width="98"><COLGROUP><COL style="width:74pt;mso-width-source:userset;mso-width-alt:3584;mso-outline-parent:collapsed;" width="98" /></COLGROUP><TBODY><TR style="height:12.75pt;"><TD align="right" class="xl24" height="17" style="width:74pt;height:12.75pt;background-color:white;border:gainsboro 0.5pt solid;" width="98">1</TD></TR><TR style="height:12.75pt;"><TD align="right" class="xl24" height="17" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro 0.5pt solid;border-bottom:gainsboro 0.5pt solid;height:12.75pt;background-color:white;">1</TD></TR><TR style="height:12.75pt;"><TD align="right" class="xl24" height="17" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro 0.5pt solid;border-bottom:gainsboro 0.5pt solid;height:12.75pt;background-color:white;">2</TD></TR><TR style="height:12.75pt;"><TD align="right" class="xl24" height="17" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro 0.5pt solid;border-bottom:gainsboro 0.5pt solid;height:12.75pt;background-color:white;">3</TD></TR><TR style="height:12.75pt;"><TD align="right" class="xl24" height="17" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro 0.5pt solid;border-bottom:gainsboro 0.5pt solid;height:12.75pt;background-color:white;">3</TD></TR><TR style="height:12.75pt;"><TD align="right" class="xl24" height="17" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro 0.5pt solid;border-bottom:gainsboro 0.5pt solid;height:12.75pt;background-color:white;">4</TD></TR><TR style="height:12.75pt;"><TD align="right" class="xl24" height="17" style="border-right:gainsboro 0.5pt solid;border-top:gainsboro;border-left:gainsboro 0.5pt solid;border-bottom:gainsboro 0.5pt solid;height:12.75pt;background-color:white;">5</TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P></P><P></P></BODY></HTML> Wed, 06 Oct 2010 07:04:40 GMT https://community.qlik.com/t5/QlikView/transform/m-p/228721#M80727 Anonymous 2010-10-06T07:04:40Z transform https://community.qlik.com/t5/QlikView/transform/m-p/228722#M80728 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>if i understood your question.</P><P>in the output filed, just give =no.</P><P></P><P>Regards</P><P>Ren</P></BODY></HTML> Wed, 06 Oct 2010 07:45:25 GMT https://community.qlik.com/t5/QlikView/transform/m-p/228722#M80728 renjithpl 2010-10-06T07:45:25Z