Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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