I am new in qlikview, can any one tell me how to do sorting in pivot table,for following scenario
I wanted to sort the prd group of each division in descending order of there total ytd value...
Hello Friends, Can any one give me solutions of this - - -....?
I don't think you can do sorting in Pivot table, it's kind of limitation in this. Still attach your app, let me find some work around.
Chart->property->sort->select dimension Product Group->sort->Expression->write expression of total ytd value
and select descending.
Did you get required result??
If yes then close thread, If not then let me know.
sorting in Pivot table is possible only based on the dimensions and it can be done only through chart properties>Sort window alone.
You can sort using expression ....
Use sorting with expression to handle this
We can sort using Expression in pivot table,
try like this:---
=Rank(aggr(Expr to be sort,all dimensions))
Example: Rank(Aggr(Sum(Sales),Year,Quarter,Month)) here Sum(Sales) is the expression to be sorted and year,Quarter,month are the dimensions used in pivot table
Retrieving data ...