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

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

deepakqlikview_123 — Fri, 17 Jul 2015 07:33:03 GMT

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.

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

deepakqlikview_123 — Fri, 17 Jul 2015 08:11:18 GMT

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

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

Gysbert_Wassenaar — Fri, 17 Jul 2015 08:21:09 GMT

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.

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

morganaaron — Fri, 17 Jul 2015 08:23:20 GMT

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?

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

deepakqlikview_123 — Fri, 17 Jul 2015 11:45:02 GMT

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

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

sunny_talwar — Fri, 17 Jul 2015 12:09:03 GMT

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

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

deepakqlikview_123 — Fri, 17 Jul 2015 12:10:40 GMT

hi ,

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

thanks

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

sunny_talwar — Fri, 17 Jul 2015 12:21:52 GMT

May be this:

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

Attaching the qvw back for reference.

Best,

Sunny

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

deepakqlikview_123 — Fri, 17 Jul 2015 15:08:16 GMT

Thanks sunny, your solution rocks

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

sunny_talwar — Fri, 17 Jul 2015 15:12:10 GMT

Awesome

I am glad I was able to help.

Best,

Sunny