topic Want to Pivot in Script.... in App Development

topic Want to Pivot in Script.... in App Development https://community.qlik.com/t5/App-Development/Want-to-Pivot-in-Script/m-p/133215#M9397 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I have columns contaiting some ageing bucket which i want to do transpose in script....</P><P></P><P>  </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 267px;"><TBODY><TR><TD align="left" class="xl65" height="20" width="119">Name</TD><TD align="left" class="xl65" style="border-left: none;" width="148">Ageing</TD></TR><TR><TD align="left" class="xl65" height="20" style="border-top: none;">Agent</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">8_>=365 Days</TD></TR><TR><TD align="left" class="xl65" height="20" style="border-top: none;">Agent  1</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">7_271-365 Days</TD></TR><TR><TD align="left" class="xl65" height="20" style="border-top: none;">Agent  1</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">6_181-270 Days</TD></TR><TR><TD align="left" class="xl65" height="20" style="border-top: none;">Agent  1</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">5_91-180 Days</TD></TR><TR><TD align="left" class="xl65" height="20" style="border-top: none;">Agent  1</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">4_61-90 Days</TD></TR><TR><TD align="left" class="xl65" height="20" style="border-top: none;">Agent  1</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">2_0-30 Days</TD></TR><TR><TD align="left" class="xl65" height="20" style="border-top: none;">Agent  1</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">3_31-60 Days</TD></TR><TR><TD align="left" class="xl65" height="20" style="border-top: none;">Agent  1</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">1_Less Than 0</TD></TR><TR><TD align="left" class="xl65" height="20" style="border-top: none;"></TD><TD align="left" class="xl65" style="border-top: none; border-left: none;"></TD></TR></TBODY></TABLE><P></P><P>want to change like below through script....</P><P></P><P>         </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 920px;"><TBODY><TR><TD align="left" height="20" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="92">Row Labels</TD><TD align="left" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="114">1_Less Than 0</TD><TD align="left" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="79">2_0-30 Days</TD><TD align="left" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="86">3_31-60 Days</TD><TD align="left" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="86">4_61-90 Days</TD><TD align="left" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="94">5_91-180 Days</TD><TD align="left" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="101">6_181-270 Days</TD><TD align="left" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="101">7_271-365 Days</TD><TD align="left" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="88">8_>=365 Days</TD><TD align="left" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="79">Grand Total</TD></TR><TR><TD class="xl65" height="20">Agent </TD><TD></TD><TD></TD></TR><TR><TD class="xl65" height="20">Agent  1</TD><TD></TD><TD></TD></TR><TR><TD class="xl65" height="20" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: 0.5pt solid #8ea9db; border-right: none; border-bottom: none; border-left: none; background: #d9e1f2;">Grand Total</TD><TD></TD><TD></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 24 Oct 2018 14:07:59 GMT nasirsaikh 2018-10-24T14:07:59Z Want to Pivot in Script.... https://community.qlik.com/t5/App-Development/Want-to-Pivot-in-Script/m-p/133215#M9397 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I have columns contaiting some ageing bucket which i want to do transpose in script....</P><P></P><P>  </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 267px;"><TBODY><TR><TD align="left" class="xl65" height="20" width="119">Name</TD><TD align="left" class="xl65" style="border-left: none;" width="148">Ageing</TD></TR><TR><TD align="left" class="xl65" height="20" style="border-top: none;">Agent</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">8_>=365 Days</TD></TR><TR><TD align="left" class="xl65" height="20" style="border-top: none;">Agent  1</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">7_271-365 Days</TD></TR><TR><TD align="left" class="xl65" height="20" style="border-top: none;">Agent  1</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">6_181-270 Days</TD></TR><TR><TD align="left" class="xl65" height="20" style="border-top: none;">Agent  1</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">5_91-180 Days</TD></TR><TR><TD align="left" class="xl65" height="20" style="border-top: none;">Agent  1</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">4_61-90 Days</TD></TR><TR><TD align="left" class="xl65" height="20" style="border-top: none;">Agent  1</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">2_0-30 Days</TD></TR><TR><TD align="left" class="xl65" height="20" style="border-top: none;">Agent  1</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">3_31-60 Days</TD></TR><TR><TD align="left" class="xl65" height="20" style="border-top: none;">Agent  1</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">1_Less Than 0</TD></TR><TR><TD align="left" class="xl65" height="20" style="border-top: none;"></TD><TD align="left" class="xl65" style="border-top: none; border-left: none;"></TD></TR></TBODY></TABLE><P></P><P>want to change like below through script....</P><P></P><P>         </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 920px;"><TBODY><TR><TD align="left" height="20" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="92">Row Labels</TD><TD align="left" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="114">1_Less Than 0</TD><TD align="left" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="79">2_0-30 Days</TD><TD align="left" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="86">3_31-60 Days</TD><TD align="left" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="86">4_61-90 Days</TD><TD align="left" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="94">5_91-180 Days</TD><TD align="left" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="101">6_181-270 Days</TD><TD align="left" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="101">7_271-365 Days</TD><TD align="left" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="88">8_>=365 Days</TD><TD align="left" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: none; border-right: none; border-bottom: 0.5pt solid #8ea9db; border-left: none; background: #d9e1f2;" width="79">Grand Total</TD></TR><TR><TD class="xl65" height="20">Agent </TD><TD></TD><TD></TD></TR><TR><TD class="xl65" height="20">Agent  1</TD><TD></TD><TD></TD></TR><TR><TD class="xl65" height="20" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri, sans-serif; border-top: 0.5pt solid #8ea9db; border-right: none; border-bottom: none; border-left: none; background: #d9e1f2;">Grand Total</TD><TD></TD><TD></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 24 Oct 2018 14:07:59 GMT https://community.qlik.com/t5/App-Development/Want-to-Pivot-in-Script/m-p/133215#M9397 nasirsaikh 2018-10-24T14:07:59Z Re: Want to Pivot in Script.... https://community.qlik.com/t5/App-Development/Want-to-Pivot-in-Script/m-p/133216#M9398 <HTML><HEAD></HEAD><BODY><P>You need generic load</P><P><A href="https://community.qlik.com/qlik-blogpost/3629">The Generic Load</A></P></BODY></HTML> Wed, 24 Oct 2018 14:42:08 GMT https://community.qlik.com/t5/App-Development/Want-to-Pivot-in-Script/m-p/133216#M9398 dplr-rn 2018-10-24T14:42:08Z