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: 
madhubabum
Creator
Creator

Sorting Problem ?

Hai all

     I got Two exp in a BarChart . I am not getting a proper descending order ..How to achieve this.

Example : Sum(Profit),Sum(Discount) in expressions

                 Profit_Center as a Dimension .

 

Thank You .

Madhu Babu

7 Replies
sunny_talwar

Are you trying to sort it by descending order of Profit or Discount?

Have you tried sorting by the Y-value Descending?

buzzy996
Master II
Master II

try tis,

desc.PNG

avinashelite

Hi Madhu,

try with the expression option in the sort tab, there you can write the sorting order you want .

Try with sum(Profit) or sum(Discount)

madhubabum
Creator
Creator
Author

Screenshot (1).png

Hi All ,

          I don't have Y-Value option in Sorting Tab...

avinashelite

can you please share your app

awhitfield
Partner - Champion
Partner - Champion

Hi Madhu,

try this

In the sort tab, click on your profit centre dimension (MAR?) and tick expression > ascending and expression as Sum(Profit)

Andy

jonas_rezende
Specialist
Specialist

Hi.

Do steps follow:

  1. In sort tab, dimension area , choice the order of classification, utilize Promote and Demote;
  2. In first dimension, Expression checkbox, insert the Sum(Profit) or Sum(Discount);
  3. After, remove others checkbox;
  4. Finally, click Ok.

Hope this help!