Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sort by expression in pivot with a macro

Hello everybody

I'm working with pivot table with years and quarters pivoted and need to sort by expressions

The expressions i have: amount and an annual growth rate, I can sort by any amount but not growth rate

The main doubt i have is, can i use 'ColumnNo()' function for using in a SortByExpression in macros ??

Why this function? To calculate de annual growth rate

Apparently this does not work, any ideas ??

I attached the sample, thanks in advance

0 Replies