topic Dynamic sort order generation in QlikView

topic Dynamic sort order generation in QlikView https://community.qlik.com/t5/QlikView/Dynamic-sort-order-generation/m-p/480036#M179402 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>     I have data in my source system as mentioned below:</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 252px;"><TBODY><TR><TD class="xl65" height="20" width="121">s_name</TD><TD class="xl66" style="border-left: none;" width="131"> Sort Order</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">P+</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">P-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">A+</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">3</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">A-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">4</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">B+</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">5</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">B-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">6</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Client</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">9999</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Consultant</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">9999</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Home Office</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">9999</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Inactive Dealer</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">9999</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Prospect</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">9999</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Terminated Client</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">9999</TD></TR><TR><TD class="xl69" height="21" style="border-top: none;">_(Null)</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">9999</TD></TR></TBODY></TABLE><P></P><P>As we want replace 9999 with following sequence if any one adds new s_name and gives 9999 it should be marked with correct sort order.</P><P></P><P>Here is the output we are looking for :</P><TABLE border="0" cellpadding="0" cellspacing="0" width="252"><TBODY><TR><TD class="xl65" height="20" width="121">s_name</TD><TD class="xl66" style="border-left: none;" width="131"> Sort Order</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">P+</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">P-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">A+</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">3</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">A-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">4</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">B+</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">5</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">B-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">6</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Client</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">7</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Consultant</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">8</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Home Office</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">9</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Inactive Dealer</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">10</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Prospect</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">11</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Terminated Client</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12</TD></TR><TR><TD class="xl69" height="21" style="border-top: none;">_</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">13</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 17 Jun 2013 21:29:43 GMT Anonymous 2013-06-17T21:29:43Z Dynamic sort order generation https://community.qlik.com/t5/QlikView/Dynamic-sort-order-generation/m-p/480036#M179402 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>     I have data in my source system as mentioned below:</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 252px;"><TBODY><TR><TD class="xl65" height="20" width="121">s_name</TD><TD class="xl66" style="border-left: none;" width="131"> Sort Order</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">P+</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">P-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">A+</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">3</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">A-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">4</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">B+</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">5</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">B-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">6</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Client</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">9999</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Consultant</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">9999</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Home Office</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">9999</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Inactive Dealer</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">9999</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Prospect</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">9999</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Terminated Client</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">9999</TD></TR><TR><TD class="xl69" height="21" style="border-top: none;">_(Null)</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">9999</TD></TR></TBODY></TABLE><P></P><P>As we want replace 9999 with following sequence if any one adds new s_name and gives 9999 it should be marked with correct sort order.</P><P></P><P>Here is the output we are looking for :</P><TABLE border="0" cellpadding="0" cellspacing="0" width="252"><TBODY><TR><TD class="xl65" height="20" width="121">s_name</TD><TD class="xl66" style="border-left: none;" width="131"> Sort Order</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">P+</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">P-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">A+</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">3</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">A-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">4</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">B+</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">5</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">B-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">6</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Client</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">7</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Consultant</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">8</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Home Office</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">9</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Inactive Dealer</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">10</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Prospect</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">11</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Terminated Client</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12</TD></TR><TR><TD class="xl69" height="21" style="border-top: none;">_</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">13</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 17 Jun 2013 21:29:43 GMT https://community.qlik.com/t5/QlikView/Dynamic-sort-order-generation/m-p/480036#M179402 Anonymous 2013-06-17T21:29:43Z