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: 
sergio0592
Specialist III
Specialist III

Sort with total issue

Hi all,

In a bar chart, i add total with checking "Show total" in dimension limits tab. So, i get in my attached sample :

Country A, B, C, D and Total

But i'am unable to make a descending sort, with Total at the top, after country D, country A,...etc

Any idea?

Thanks

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Looks like it is back now....

Try this

Fact:
LOAD * INLINE [
    Country, Sales
    A, 45
    B, 12
    C, 36
    D, 78
];

Dim:
LOAD * INLINE [
    Dim
    1
    2
];

and then dimension

=Pick(Dim, Country, 'Total')

Expression

Sum(Sales)

Sorting - Select sorting by Y-value Descending

View solution in original post

4 Replies
sunny_talwar

Am I the only one seeing '(Virus scan in progress...)' or everyone else is also seeing this?

image.png

marcus_malinow
Partner - Specialist III
Partner - Specialist III

Me too

sunny_talwar

Looks like it is back now....

Try this

Fact:
LOAD * INLINE [
    Country, Sales
    A, 45
    B, 12
    C, 36
    D, 78
];

Dim:
LOAD * INLINE [
    Dim
    1
    2
];

and then dimension

=Pick(Dim, Country, 'Total')

Expression

Sum(Sales)

Sorting - Select sorting by Y-value Descending

sergio0592
Specialist III
Specialist III
Author

Great, thank you!!