Sorting issues in Qliksense Barchart

[manojkumargowda]

Hi All,

I'm facing a sorting issue in Bar chart. As you can see below, Null BranchName (with sales=800) needs to sorted to last, but rest needs to be sorted by descending order. But its not working. please refer below screenshots and table used is a simple inline load as below.

Table:

Set NullInterpret = '';

LOAD * INLINE [
    BranchNo, BranchName, Sales
    0003, Zyger Valley, 150
    0001, Blr Office, 100
    0004, Mys Office,400
    0003, Palm Grove, 200
    0004,,300
    0004,,400
    0004,,100
];

[balabhaskarqlik]

Try these:

In Sort by Expression

Expression

If(IsNull(BranchName), BranchName,'')

Or

If(IsNull(BranchName), '',BranchName)

[mdmukramali · Accepted solution]

Hi,

Try Sort by Expression :

=Aggr(sum(Sales),BranchName)

PFA.

Thanks,

Mukram.

[manojkumargowda]

Hi Bala,

It is not working. Please post the qvf file if it is working in your end. Thanks.

[manojkumargowda]

Great. It worked.

Thanks Mohammed