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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
lucarizziero
Partner - Contributor III
Partner - Contributor III

order by expression in the 4th dimension of a pivot table

Hi,

I have a pivot table [full pivot] with 7 dimensions and 2 expressions  ([quantity] and [Total by Cust.]).

I need to order the first 3 dimensions by the text string, while the fourth (customer) being ordered by an ABC analisys of the quantity.

Even if I'm able to represent correctly the [Total by Cust.] column (expression #2), QlikView seems not consider it in the right way when being usend as an order expression.

Thanks in advance.

Luca

0 Replies