topic Re: ListBox Not Sorting Properly!!! in QlikView

ListBox Not Sorting Properly!!!

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: ListBox Not Sorting Properly!!!

tresB — Mon, 07 Mar 2016 11:22:21 GMT

Is there any expression written for custom sort order ?

Re: ListBox Not Sorting Properly!!!

Mon, 07 Mar 2016 12:05:38 GMT

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.

Re: ListBox Not Sorting Properly!!!

avinashelite — Mon, 07 Mar 2016 12:09:15 GMT

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

Re: ListBox Not Sorting Properly!!!

swuehl — Mon, 07 Mar 2016 12:11:49 GMT

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?

Re: ListBox Not Sorting Properly!!!

Mon, 07 Mar 2016 12:12:59 GMT

Sorry Avinash. i didnt get you.

Re: ListBox Not Sorting Properly!!!

Mon, 07 Mar 2016 12:18:56 GMT

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

Re: ListBox Not Sorting Properly!!!

avinashelite — Mon, 07 Mar 2016 12:20:18 GMT

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

Re: ListBox Not Sorting Properly!!!

Mon, 07 Mar 2016 12:40:10 GMT

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

Re: ListBox Not Sorting Properly!!!

avinashelite — Mon, 07 Mar 2016 12:49:11 GMT

if your using the expression for sorting try like this .

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

Re: ListBox Not Sorting Properly!!!

Mon, 07 Mar 2016 13:10:04 GMT

Obviously. I have done that.

Re: ListBox Not Sorting Properly!!!

swuehl — Mon, 07 Mar 2016 13:14:05 GMT

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.

Re: ListBox Not Sorting Properly!!!

Tue, 08 Mar 2016 12:38:09 GMT

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

Re: ListBox Not Sorting Properly!!!

Tue, 08 Mar 2016 14:28:36 GMT

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.