Polling Numbers

Getting Started
1

Hi,

If I have a listbox with 100 rows and the value is randomly changed.
how to get 10 rows with bigger value, sorted from bigger to smaller.

thanks
regards,
arief

2

Dont understand the question.

3

Hi Mr. Tullin.

Basically I want to make ranking for the larger number based from listbox.

For example,
A have data in a listbox like,

Name. Sales

Orange 500
Apple 1500
Banana 10

So want to put ranking label on it

The result should be

Rank 1. Apple. - apple ranking 1st because apple sales is higher
Rank 2. Orange
Rank 3. Banana

So, if i had 100 rows or more, the ranking label should read the higher one.

Thanks
Arief

4

Do you simply want to sort the Listbox based on the values in Column(1) or do you also want to add a new Column and add Rank <#1> … Rank <last #> ?

In all cases, you have to set code to sort numerically your values in the Sort Event (to add).
Once the above is done and if you want that, Insert a Column in Position #0 and place "Rank " + Format(Row,“0000”).

For the Sort algorythm, you have to search in this forum if the LR (Listbox) does not provide an example (I forgot). The second one is easier.

5

Assuming you don’t want to sort the listbox, create two arrays. The first will hold the values you want to sort, the second the ListIndex of that values. Then sort the first array with the second (SortWith). The index of each element in the second array will be its ranking.

6

Hi,

Yes, I don’t want to sort the listbox. I will give a try with an array.

thanks
regards,
arief

7

Too hard to code ? If so, there is an entry there ListBox (deprecated) — Xojo documentation

Search for Custom Sorting (and the example).

8

No Emile, he means he doesn’t WANT the listbox to be sorted, not that he doesn’t want to “to the work”

9

Sorry.

10

very useful is storing objects (or data) in a rowtag or celltag.

11

I think, better and faster way is to create in memory sqlite DB, fill it with data and fill the listbox from it.
When you need to do something with data, use sqlite and feel the power.

It is easy to keep things in merge just by creating few methods, which will update both, the sqlite and the listbox

12

Thanks,

this method is more easier…

regards,
Arief