Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sergio0592
Valued Contributor II

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

Re: Sort with total issue

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

4 Replies

Re: Sort with total issue

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

image.png

marcus_malinow
Valued Contributor III

Re: Sort with total issue

Me too

Re: Sort with total issue

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

Re: Sort with total issue

Great, thank you!!