topic Re: List Box sync in QlikView

List Box sync

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have two list boxes, one lists our customer's names and one lists the customers code (A001 format) in our system. At present these are sorting in alphabetical order which is fine but reading in line between the two they do not sync. I wish to leave the customer code in alphabetical order but sync the names to them.

Re: List Box sync

Anil_Babu_Samineni — Wed, 14 Sep 2016 09:57:37 GMT

Try to use sort with load original from sort tab

Re: List Box sync

ToniKautto — Wed, 14 Sep 2016 10:01:14 GMT

I think the clearest solution is to enumerate the values during load. This will keep your front-end nice and clean, and allow accomplishing the required sort by sorting the field numerically instead of text based or with an advanced sort expression. See attached fro an example.

Re: List Box sync

trdandamudi — Wed, 14 Sep 2016 10:02:23 GMT

In the 'Name' list box go to 'Sort' tab and follow as below:

Note: As Toni mentioned below, my option works only if Customer is a numeric value,

Re: List Box sync

ToniKautto — Wed, 14 Sep 2016 10:10:19 GMT

That is not a feasible solution.

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/List_Box.htm

Re: List Box sync

trdandamudi — Wed, 14 Sep 2016 10:28:58 GMT

It was a mistake, I thought it was numeric... I will update the post.....

Re: List Box sync

martinpohl — Wed, 14 Sep 2016 10:53:03 GMT

so if isn't numeric use maxstring(Customer) instead.

Each customer number has one text field, so each value will get the description from the customer field.

Regards

Re: List Box sync

ToniKautto — Wed, 14 Sep 2016 11:00:07 GMT

MaxString() returns a text. It is not a valid expression for sorting, as a number is required.

Re: List Box sync

martinpohl — Wed, 14 Sep 2016 11:10:36 GMT

for me it works

the field Dim1num is sorted by the alphabetic order of Dim1

Regards

Re: List Box sync

ToniKautto — Wed, 14 Sep 2016 11:31:13 GMT

From that image I can not tell exactly what configuration you have applied. Can you provide the sample file?

MaxString() returns a dual value, but for this value to be possible to interpret as a number the field must have been enumerate at some stage. Num(MaxString('A')) for example returns a NULL values, since the max string of a text can not be anything else than a text. So for pure text values MaxString() can not be used in sort expressions.

Re: List Box sync

Anonymous — Wed, 14 Sep 2016 13:35:15 GMT

Thanks for the input. I have found a temporary solution utilising a Table Box which has synced as required and added a 'Customer Search'

Re: List Box sync

chetansehgal — Fri, 16 Sep 2016 09:22:00 GMT

Try Using Dual on both the fields, but only if both are at the same granular level. After doing that sort both the fields Numerically on UI.

e.g.

temp:

LOAD * INLINE [

F1, F2

aa, g

ab, d

sd, a

tr, b

we, gg

fd, zz

c, kk

] ;

NoConcatenate

Sort:

load Dual(F1,Autonumber(F1)) as F1,Dual(F2,AutoNumber(F2)) as F2 Resident temp Order by F1 asc;

drop Table temp;