Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
madhubabum
Contributor

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

Re: Sorting Problem ?

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

Have you tried sorting by the Y-value Descending?

buzzy996
Honored Contributor II

Re: Sorting Problem ?

try tis,

desc.PNG

Re: Sorting Problem ?

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
Contributor

Re: Sorting Problem ?

Screenshot (1).png

Hi All ,

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

Re: Sorting Problem ?

can you please share your app

Partner
Partner

Re: Sorting Problem ?

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
Valued Contributor

Re: Sorting Problem ?

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!