Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

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
Master III
Master III

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

Use this in the expression

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

Not applicable
Author

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