topic Straight chart order by expression in QlikView

Straight chart order by expression

Fri, 19 Mar 2010 14:44:02 GMT

Afternoon All,

I have a straight chart I am using to display a reconciliation between 2 sources. I would like to have the chart ordered by the size of any differences in the 2 sources. So for my dimensions I have Date, Account, Currency and for my Expressions I have:

Sum(SourceA)

Sum(SourceB)

Sum(SourceA) - Sum(SourceB) (Label: Diff)

fabs(Sum(SourceA) - Sum(SourceB)) (Label: AbsDiff)

And on the Sort tab I have select Sort by Expression, Descending, with this as the expression:

fabs(Sum(SourceA) - Sum(SourceB)) (Label: AbsDiff)

But it doesn't appear to be sorting the data at all! What am I doing wrong?

TIA,

Tony

Straight chart order by expression

Fri, 19 Mar 2010 16:08:44 GMT

Have you switched on the checkbox for override group sort order?

If you haven't, switch it on and try again.

Straight chart order by expression

Fri, 19 Mar 2010 16:31:32 GMT

That checkbox is greyed out for all columns in the Priorty list.

I think I've got round it by promoting my AbsDiff field to the top of that Priority list and then just sort descending on it. However, idelly i'd like not to display this field (AbsDiff) but just use it for the sorting.... Do you know if I can do that?

Thanks for your help,

Tony

Straight chart order by expression

Fri, 19 Mar 2010 16:46:17 GMT

I seem to remember that this becomes greyed out when the other checkbox (allow interactive sort) is either on or off, so try checking/un-checking that box to see if the override sort order becomes available.

Straight chart order by expression

Fri, 19 Mar 2010 17:18:55 GMT

Nope, the checkbox is greyed out whether Allow Interactive Sort is checked or unchecked.

In the help file it says Override Group Sort Order "is only available when a group dimension is selected in the Priority list ", but I'm not sure what a group dimension is. I don't think I'm using them.

The sorting is working now and I've managed to hide the column from the Presentation sheet.

Thanks,

Tony