# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for
Did you mean:
Not applicable

## Sort order on calculated column

Please could  someone assist me in putting a sort on the following data:

CatNo=Sum (total_inv_line_value*invnewproduct)
ShortDescription
A                63778.16Blue
B                                     1005269.22Green
C                     31500Yellow
D                     47914Red

I need to sort the column which is based on the expression t descending Value.

ALSO Id be very happy if someone could tell me how to show the values (once in descending order) as:

1005269 M

63778 K

47914 K

31500 M

Need to round and have the correct format symbol (M or T)

Thank you !!

1 Solution

Accepted Solutions
MVP

No problem. Please look at the attached qvw and see if this is helpful.

Best,

Sunny

10 Replies
Specialist

Emma,

Have you tried to change the sorting options you have in the Sort tab in object properties?

Marc.

MVP

How do you determine if we need to add a M or K?

Best,
Sunny

Not applicable
Author

7 spaces to the left of the decimal

Creator II

to sort on the value use the expression option in sort tab and put in the expression you want to sort on. ie the calculation  =sum(total...)

o vary between M and k i'm assuming you mean Million of thousand, probably best/easiest to pick the appropriate one and divide by 1000 (or 1000000) and use the number format tab to include k (or M) in the format. note its a small k for thousand not capital.

MVP

So the one in the red isn't right, right?

1005269 M

63778 K

47914 K

31500 M (Should be K here?)

Just making sure I understand this well enough.

Best,

Sunny

Not applicable
Author

Yes, apologies Sunny

Not applicable
Author

hello please find attached QVW for the sorting order...

MVP

No problem. Please look at the attached qvw and see if this is helpful.

Best,

Sunny

Not applicable
Author

This has worked perfectly Sunny.

I really appreciate your help with this one!

Many thanks