Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to get required order in pivot table

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.

3 Replies
Highlighted
Employee
Employee

Re: How to get required order in pivot table

Create another table:

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

    F1

    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

Highlighted
Not applicable

Re: How to get required order in pivot table

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

Highlighted
Specialist
Specialist

Re: How to get required order in pivot table

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,