Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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...
Hi,
Chart->property->sort->select dimension Product Group->sort->Expression->write expression of total ytd value
and select descending.
Regards
Hello Friends, Can any one give me solutions of this - - -....?
Hi,
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.
Regards,
Navdeep
Hi,
Chart->property->sort->select dimension Product Group->sort->Expression->write expression of total ytd value
and select descending.
Regards
Hu Pawar,
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 ....
Ramya.
Use sorting with expression to handle this
Hi Sujeetsingh,
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
Thanxxx.... alot...
Welcome..
Did you get required result??
If yes then close thread, If not then let me know.
Regards
Yes..