Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

Not applicable

Pivote Sort


Hi All,

Can any one help on the below issue.

I have a pivot table shown below

BEFORE
PHYSICANVALUE
OTHERS476
FETES56
CROTZER76
GERSHMAN99
JOSEPH123
BAXTER34
JOHN56
TOTAL920

Now I want the "OTHERS" category to be shown at the bottom (Shown below)

AFTER
PHYSICANVALUE
FETES56
CROTZER76
GERSHMAN99
JOSEPH123
BAXTER34
JOHN34

OTHERS

476

TOTAL920

Note: I dont want to use the sort values by Accending here. Only the Other should be shown below and the rest should remain the same.

Thanks in advance.

Regards,

KK

3 Replies
maleksafa
Valued Contributor

Re: Pivote Sort

Hi,

you can use the dual function to assign a number for the values and give 'OTHERS' the highest number and sort by numeric value asc.

anbu1984
Honored Contributor III

Re: Pivote Sort

Chart properties --> Sort --> Dimension( Select the dimension )

Use this in the expression

If(PHYSICAN<> 'OTHERS',1,2)

Not applicable

Re: Pivote Sort

Hi Anbu,

Thanks for your reply,

But I have a issue here,,,

In my SORT DIMENSION I have already a expression

"({<Product,AST_PROMO_FLG,Product,$(v26Weeks)>} $(vVALUE)) " so where can I put this function  "If(PHYSICAN<> 'OTHERS',1,2)"

Thanks,

KK

Community Browser