topic Sort by expression in pivot with a macro in QlikView https://community.qlik.com/t5/QlikView/Sort-by-expression-in-pivot-with-a-macro/m-p/1107745#M890445 <HTML><HEAD></HEAD><BODY><P>Hello everybody</P><P></P><P>I'm working with pivot table with years and quarters pivoted and need to sort by expressions</P><P>The expressions i have: amount and an annual growth rate, I can sort by any amount but not growth rate</P><P></P><P>The main doubt i have is, can i use 'ColumnNo()' function for using in a SortByExpression in macros ??</P><P>Why this function? To calculate de annual growth rate</P><P></P><P>Apparently this does not work, any ideas ??</P><P></P><P>I attached the sample, thanks in advance</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Sort by expression in pivot with a macro https://community.qlik.com/t5/QlikView/Sort-by-expression-in-pivot-with-a-macro/m-p/1107745#M890445 <HTML><HEAD></HEAD><BODY><P>Hello everybody</P><P></P><P>I'm working with pivot table with years and quarters pivoted and need to sort by expressions</P><P>The expressions i have: amount and an annual growth rate, I can sort by any amount but not growth rate</P><P></P><P>The main doubt i have is, can i use 'ColumnNo()' function for using in a SortByExpression in macros ??</P><P>Why this function? To calculate de annual growth rate</P><P></P><P>Apparently this does not work, any ideas ??</P><P></P><P>I attached the sample, thanks in advance</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sort-by-expression-in-pivot-with-a-macro/m-p/1107745#M890445 2020-11-25T16:16:04Z