topic Re: Sort with total issue in QlikView

Sort with total issue

sergio0592 — Sat, 16 Nov 2024 21:25:00 GMT

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

sunny_talwar — Wed, 13 Feb 2019 13:44:11 GMT

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

marcus_malinow — Wed, 13 Feb 2019 13:58:06 GMT

Me too

sunny_talwar — Wed, 13 Feb 2019 14:04:30 GMT

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 — Wed, 13 Feb 2019 16:18:32 GMT

Great, thank you!!