ListBox Not Sorting Properly!!!

[#1]

Dear QVExperts,

A Dashboard has multiple List Boxes.

Section Access Implemented. If login as an Admin/Admin user & also as a normal user from QlikView Developer Edition, the list box values are sorted descending & it displays correctly.

When we login into Accesspoint & View the dashboard as an Admin User still it is displaying correctly.

But as a individual business user if we login, the List box is not sorted descending.

Initially it sorts as the Distributor No & then it sorts with values Descending. It is quite surprising.

Anyone having any ideas, Can you please suggest me on this.

Thanks

[#2]

Obviously. I have done that.

[swuehl]

AFAIK, there is no admin user when accessing the QVW in access point, all users have the same (USER) rights.

So I believe the difference originates from the section access (you are using data reduction as well, right?)

Kind of strange that you get different results in desktop and server for the normal users.

But I would suggest looking into the sections access table and the reduction fields.

[#4]

Dear QV Experts,

Greetings for the day!!!

In continuation, i tried editing the Custom Sort like this,

Instead of this,

=num(Sum({$<Date={">=$(CYStartDate)<=$(vMaxDate)"}>} CustomerSales)/1000, '$ #,##0 K')

Used like this,

num(Sum(CustomerSales),'$#,##0')

Now i am getting sorted descending but not completely, please find the screenshot below,

Please suggest me on this.

Thanks,

Sasikumar

[#5 · Accepted solution]

Dear QV Experts,

The issue is resolved.

Used the same expression in the Custom Sort also & it now worked.

=If(Metrics ='Case',num(Sum({$<Date={">=$(CYStartDate)<=$(vMaxDate)"}>} CustomerCases),'#,##0'),
If(Metrics ='Dollar',num(Sum({$<Date={">=$(CYStartDate)<=$(vMaxDate)"}>} CustomerSales)/1000,'$#,##0'),
If(Metrics ='Each',num(Sum({$<Date={">=$(CYStartDate)<=$(vMaxDate)"}>} CustomerEach)/1000,'#,##0'))))

Thanks a lot for your valued suggestions.