Fist sorted value is not working for negative numbers.Not showing results properly

[deepakqlikview_123]

PFA

Fist sorted value is not working for negative numbers.Not showing results properly.

I have applied expression in sort tab as per sorting as per expression but it is not working for negative numbers .

showing wrongly sorted values.

[deepakqlikview_123]

I have applied expression in sort tab as per sorting as per expression but it is not working for negative numbers .

showing wrongly sorted values.

below is the expression that i have used.

=FirstSortedValue(aggr (sum(INDICATOR_VALUE),MONTH,NEW_INDICATOR_NAME), -aggr(MONTH,NEW_INDICATOR_NAME,MONTH))   in sort tab .

but in ascending order of chart results are wrong.

Thanks

[Gysbert_Wassenaar]

Your sort expression aggregates using two dimensions, but your chart has only one of those two dimensions. That doesn't make sense.

but in ascending order of chart results are wrong.

You specified Descending order on the Sort tab, not Ascending. So you get a chart sorted by Descending values.

[morganaaron]

Hi Deepak.

I put your sort expression into an expression so you can see what it's returning:

The table is sorting correctly based on the value you're returning. What are you wanting to sort by? Your expression is pretty confusing given the results you're trying to show. Why not just sort using your expression too?

[deepakqlikview_123]

Hi All,

Still it is not working can you please suggest what i need to do on this.

can you please provide me sample for this

thanks

[sunny_talwar]

If what Aaron‌‌ is showing is not the order you are looking for, what is your expected sort order?

[deepakqlikview_123]

hi ,

I want to sort bars in bar chart as per descending order of their values

thanks

[sunny_talwar · Accepted solution]

May be this:

=Num(Avg({1<DATE={'$(vS&P500)'}>}INDICATOR_VALUE),'#,##0.00')/100

Attaching the qvw back for reference.

Best,

Sunny

[deepakqlikview_123]

Thanks sunny, your solution rocks

[sunny_talwar]

Awesome

I am glad I was able to help.

Best,

Sunny