topic Re: inline in QlikView https://community.qlik.com/t5/QlikView/inline/m-p/838108#M1007258 <HTML><HEAD></HEAD><BODY><P>Along with @Marcus Dual() function inline load, U can try the below option too.<IMG alt="5.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/92298_5.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 08 Jul 2015 18:50:24 GMT Qrishna 2015-07-08T18:50:24Z inline https://community.qlik.com/t5/QlikView/inline/m-p/838106#M1007256 <HTML><HEAD></HEAD><BODY><P>I want to sort this table in sort by actual order. i did&nbsp; the load in qlick view this table but doe not short to actual order. i try to sort this table in default order. but in that&nbsp; function not work. please help the sort to inline mode. script details as follows. (<STRONG>bcod,month,year and branch is crosstable)</STRONG></P><P>&nbsp; sagara </P><P></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 103px;"><TBODY><TR><TD class="xl63" height="20" width="103"><STRONG> BCOD </STRONG></TD></TR><TR><TD class="xl63" height="20"><STRONG> MONTH </STRONG></TD></TR><TR><TD class="xl63" height="20"><STRONG> YEAR </STRONG></TD></TR><TR><TD class="xl63" height="20"><STRONG> BRANCH </STRONG></TD></TR><TR><TD class="xl63" height="20"><STRONG> DIR_PRM </STRONG></TD></TR><TR><TD class="xl63" height="20"><STRONG> DBT_STL </STRONG></TD></TR><TR><TD class="xl63" height="20"><STRONG> SAL_SALE </STRONG></TD></TR><TR><TD class="xl63" height="20"><STRONG> INT_INC </STRONG></TD></TR><TR><TD class="xl63" height="20"><STRONG> RNT_INC </STRONG></TD></TR><TR><TD class="xl63" height="20"><STRONG> SND_INC </STRONG></TD></TR><TR><TD class="xl63" height="20"><STRONG> EXC_COL </STRONG></TD></TR><TR><TD class="xl63" height="20"><STRONG> RTN_STL </STRONG></TD></TR><TR><TD class="xl64" height="20"><STRONG> TOT_COL </STRONG></TD></TR><TR><TD class="xl65" height="21"><STRONG> ADM_EXP </STRONG></TD></TR><TR><TD class="xl65" height="21"><STRONG> AGM_EXP </STRONG></TD></TR><TR><TD class="xl65" height="21"><STRONG> CLM </STRONG></TD></TR><TR><TD class="xl65" height="21"><STRONG> CLM_PRO </STRONG></TD></TR><TR><TD class="xl65" height="21"><STRONG> COM </STRONG></TD></TR><TR><TD class="xl66" height="21"><STRONG> FIN_EXP </STRONG></TD></TR><TR><TD class="xl65" height="21"><STRONG> MGT_FEE </STRONG></TD></TR><TR><TD class="xl65" height="21"><STRONG> OST_EXP </STRONG></TD></TR><TR><TD class="xl65" height="21"><STRONG> RI_FEE </STRONG></TD></TR><TR><TD class="xl65" height="21"><STRONG> RNT_ADV </STRONG></TD></TR><TR><TD class="xl65" height="21"><STRONG> RIS_DPT </STRONG></TD></TR><TR><TD class="xl65" height="21"><STRONG> SEL_EXP </STRONG></TD></TR><TR><TD class="xl65" height="21"><STRONG> STF_EXP </STRONG></TD></TR><TR><TD class="xl65" height="21"><STRONG> TAXES </STRONG></TD></TR><TR><TD class="xl65" height="21"><STRONG> FIX_AST </STRONG></TD></TR><TR><TD class="xl67" height="21"><STRONG>STF_LON</STRONG></TD></TR><TR><TD class="xl65" height="21"><STRONG> REFUND </STRONG></TD></TR><TR><TD class="xl65" height="21"><STRONG> RTN_CHQ </STRONG></TD></TR><TR><TD class="xl65" height="21"><STRONG> EXC_PAY </STRONG></TD></TR><TR><TD class="xl68" height="21"><STRONG>DIV_PAY</STRONG></TD></TR><TR><TD class="xl66" height="21"><STRONG> LEASE </STRONG></TD></TR><TR><TD class="xl66" height="21"><STRONG> TOT_PAY </STRONG></TD></TR><TR><TD class="xl67" height="21"><STRONG>NET_INF_OUT</STRONG></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 12 May 2015 03:37:32 GMT https://community.qlik.com/t5/QlikView/inline/m-p/838106#M1007256 sagaraperera 2015-05-12T03:37:32Z Re: inline https://community.qlik.com/t5/QlikView/inline/m-p/838107#M1007257 <HTML><HEAD></HEAD><BODY><P>You could sort within an inline-table load with rowno() separately or integrated with a dual-field:</P><P></P><P>table:</P><P>Load dual(FIELD, rowno()) as FIELD Inline [</P><P>FIELD</P><P>BCOD</P><P>MONTH</P><P>YEAR</P><P>BRANCH</P><P>DIR_PRM</P><P>DBT_STL</P><P>SAL_SALE</P><P>INT_INC</P><P>RNT_INC</P><P>SND_INC</P><P>EXC_COL</P><P>RTN_STL</P><P>TOT_COL</P><P>ADM_EXP</P><P>AGM_EXP</P><P>CLM</P><P>CLM_PRO</P><P>COM</P><P>FIN_EXP</P><P>MGT_FEE</P><P>OST_EXP</P><P>RI_FEE</P><P>RNT_ADV</P><P>RIS_DPT</P><P>SEL_EXP</P><P>STF_EXP</P><P>TAXES</P><P>FIX_AST</P><P>STF_LON</P><P>REFUND</P><P>RTN_CHQ</P><P>EXC_PAY</P><P>DIV_PAY</P><P>LEASE</P><P>TOT_PAY</P><P>NET_INF_OUT</P><P>];</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 12 May 2015 12:08:51 GMT https://community.qlik.com/t5/QlikView/inline/m-p/838107#M1007257 marcus_sommer 2015-05-12T12:08:51Z Re: inline https://community.qlik.com/t5/QlikView/inline/m-p/838108#M1007258 <HTML><HEAD></HEAD><BODY><P>Along with @Marcus Dual() function inline load, U can try the below option too.<IMG alt="5.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/92298_5.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 08 Jul 2015 18:50:24 GMT https://community.qlik.com/t5/QlikView/inline/m-p/838108#M1007258 Qrishna 2015-07-08T18:50:24Z