Qlik Community

Ask a Question

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 
Search instead 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
sunny_talwar

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

Best,

Sunny

View solution in original post

10 Replies
marcarreras
Specialist
Specialist

Emma,

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

Please attach a sample file for deeper understand of your requirement.

Marc.

sunny_talwar

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

tcullinane
Creator II
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.

sunny_talwar

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...

sunny_talwar

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

Best,

Sunny

View solution in original post

Not applicable
Author

This has worked perfectly Sunny.

I really appreciate your help with this one!

Many thanks