Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have created a pivot table with two dimensions ProductID, Salesman and a measure Sum(Sales)
now the issue I am seeing in Qlik Sense pivot table is the values are not sorted correctly, I was trying the sortable aggr but
couldn't get to the point, can any one give the correct syntax where the Sum(Sales) can also be sorted in asc/desc when
the table in full expanded view. see below the issue in red also attaching a qvf file.
Since the same salesman are in different Product ID, how would you want to sort them? Based on there value within a Product ID?
Check this
Dimension
=Dual(Salesman&Aggr(NODISTINCT Repeat(' ', Rank([Product ID])), [Product ID]), -Aggr(Sum(Sales), [Product ID], Salesman))
Thanks Sunny for the solution
I think I can't go with this as my chart contains 6 dimensions, some of them are Rows and some of them are columns
Aggr might screw up performance.
ok