topic Re: How to get required order in pivot table in QlikView

How to get required order in pivot table

Tue, 01 Oct 2013 15:55:39 GMT

Hi,

I have one pivot table with column as manager.

I need to get the manager order as

Carl

Adam

Caty

Ciasel

Rosy

Revanth

Dolly

Damein

Daniel

Seara

David

Christ

Amal

Durga

Candsy

Cattie

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.

Thanks.

Re: How to get required order in pivot table

Clever_Anjos — Tue, 01 Oct 2013 16:07:00 GMT

Create another table:

LOAD F1 as Manager,RowNo() as RequiredOrder INLINE [

Carl

Adam

Caty

Ciasel

Rosy

Revanth

Dolly

Damein

Daniel

Seara

David

Christ

Amal

Durga

Candsy

Cattie

];

And use "RequiredOrder" as an expression into Sort Tab of your table

Re: How to get required order in pivot table

Wed, 02 Oct 2013 09:41:05 GMT

Hi,

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

Re: How to get required order in pivot table

v_iyyappan — Wed, 02 Oct 2013 10:10:37 GMT

Hi,

Try like this,

Test:

LOAD

Recno() AS ID,

Dual(ManagerName, Recno()) as RequiredOrder;

LOAD * INLINE

[ManagerName

Carl

Adam

Caty

Ciasel

Rosy

Revanth

Dolly

Damein

Daniel

Seara

David

Christ

Amal

Durga

Candsy

Cattie];

Regards,