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

[tresesco]

Is there any expression written for custom sort order ?

[#3]

Yeah.

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

But the same custom sort in all the list boxes. Only a few having issues. Rest all sorted correctly.

[avinashelite]

I feel if you have the interactive sort than the customer might have sorted it right ??

[swuehl]

What if you (for testing only) add an expression to your list boxes, same as the sort expression.

Then for the list boxes that show the issue, examine the expression values. Do the wrongly sorted field values return the same expression value, like all zero?

Since you have section access implemented, are you using same user accounts for testing in desktop and server?

[#6]

Sorry Avinash. i didnt get you.

[#7]

Yeah. I am using the same user in Desktop & Server.

[avinashelite]

could you please share the sample screen shots ?? so that we can understand the issue

[#9]

Please find the screenshot below,

The EndCustomer ListBox displays the SalesValue Descending correctly

Where as Distributor not displaying if i login as Individual End User. But if i  login as Admin User in Access Point, I can see the Distributor values too displayed Descending correctly

Same Custom Sort is used in End Customer & Distributor list boxes.

Are there any settings in QlikView?

Thanks,

Sasikumar

[avinashelite]

if your using the expression for sorting try like this .

Go to >Properties > sort > except the sort expression uncheck rest of the check boxes