Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2016-08-29 01:54 PM

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

Labels (1)
Labels
Orden pivote.qvw
656 Views
0 Likes
0 Replies