i´m having a hard time with qlikview here. I have this multi box, with a field with alot of values (more than 5000). I have 1569 values that i need to select from this multi box....Are there any other easier ways to do it? If i select one each time, it would take forever.
If the data has a pattern that can be identified with a flag during the load, just add that flag to a table, and select the flag. The 1569 values will be automatically "selected".
If this is just a one time thing, and there's a pattern, such as "all the values I want have the substring 'ABC' in them", then click on the field, type ABC, and hit enter.
If there is no pattern at all to the data, but you'll want these 1569 values to be selected over and over, you could laboriously select them all once, then use a bookmark. But I bet there's a pattern to the data if you'll have continued interest in those specific values.
If it's a numeric field, and you want something like every value less than 2000, click on the field and type in <2000.
You can get pretty advanced with search expressions. From the help text for Advanced Search, you can do things like sum(Sales)>sum(Budget) for a Salesman field to select all salesmen with sales higher than their budget.
I have a macro that I created some time ago that allows you to paste a list from a excel spreadsheet (or any document) into a input box . The macro then scans the list and selects the items from the list. I had posted it to the forum a long time ago. Try that, our users love it.
