topic Pre-select 10 values from a list box in QlikView

Pre-select 10 values from a list box

Anonymous — Sat, 27 Jun 2015 00:08:29 GMT

Hello,

I'm wondering if it's possible to automatically select the top 10 values from a list.

With top 10 I do not mean a ranking, I mean the first 10 entries that show up based on the sort order.

This pre-selection should happen when entering the sheet (on activate sheet trigger).

Any help welcome.

Re: Pre-select 10 values from a list box

Anonymous — Sat, 27 Jun 2015 13:20:02 GMT

The solution below works, with a restriction - sort order is load order. So, if you use it, you have to load the field in the script in a specific order.

Action - select in field.

Field - FieldName

Search string - ='(' & concat(distinct if(FieldIndex('FieldName',FieldName)<=10, FieldName), '|') & ')'

If it is not exactly what you want, maybe it at least gives you an idea,

Re: Pre-select 10 values from a list box

Anonymous — Sat, 27 Jun 2015 13:40:28 GMT

Hi,

it is the same that say Michael Solomovich so thank him! 🙂

I was slower but I attach the sample file.

You can try also with a macro (you can find many post in the community) but I dont know if it is a good approach.

Good luck.

Regards.