Discussion board where members can get started with QlikView.
I have one pivot table with column as manager.
I need to get the manager order as
could anyone let me know how to get this order in the pivot table when I make any selections. Now I have this in ascending order. But I would need the order which I shown above.
Please could anyont help me.
Create another table:
LOAD F1 as Manager,RowNo() as RequiredOrder INLINE [
And use "RequiredOrder" as an expression into Sort Tab of your table
Thanks for your answer. I am getting duplicates when I used column manager in pivot table and in list box.
Could you help me why it is getting duplicates
Try like this,
Recno() AS ID,
Dual(ManagerName, Recno()) as RequiredOrder;
LOAD * INLINE