Bulk Select from Excel, etc. - Any ideas?

[#1]

Hi,

we are planning to create an application, where we want to do a bulk select. The user needs to have the possibility to select eg. 30000 distinct values at once, that he has stored in an excel sheet or something else. I have got different ideas in mind and would get your feedback and / or more ideas.

1. Storing file on network drive and doing a partial releoad - could be difficult to manage with a lot of users

2. Selecting with a Macro reading the excel file and doing the selection - seems to be quite slow

3. Doing something with the new realtime refresh .- is this possible for different users?

I bet, that there is a simple solution [:)]

Regards

Christian

[Anonymous]

When user wants to select a large amount of values, I suspect that these values should have something in common. That is, they belong to some logical group, like category. In this case by selecting one category you select multiple items that belong to it.
so, the question is not about the technology - "how to select" - but about the appropriate organizing of data.
If the grouping does not exist in data, it can be created in the data model if there is any logic benind the group. For example, a list of numeric values can be broken into intervals.

[#3]

Hi,

yes, there are cases, when the distinct values has got something in common (eg. a sales order, a box, a delivery, etc.), but in other cases they have got nothing in common (like a warranty return of eg. 1.000 serial numbers or a registration of 100.000 serial numbers). Then I would need a capability to select those distinct values. Yes, I could include it in the datamodel, but this would need a reload every time.

1. Place the file to a common share

2. Partial Reload with file name and serial numbers

3. Selection of the filename

I don't know how feasible this is with QlikView 9. With QlikView 8, where I have got a lot of experience with, this approach would have had it's drawbacks.

Regards

Christian

[Anonymous]

I'm sure you're doing something wrong. It's the most typical QV situation when user selects from a limited number of values to return as result a much larger number of records. In your case, can't you just select conditions that mean "waranty return" or "registration"? It sounds rather simple.
As for the QV9 - whatever works in 8, as a rule will work in 9.

[#5]

Hi Michael,

let's explain a use case. We have got a warranty return with 2000 serial numbers from our customer (excel) and we want to get back information for each product

--> Where has it been produced?

--> To which customer has it been sold

--> Has it been already returned in another warranty return

--> etc.

Starting point is not always the serial number, but in some cases. Sure, the data is also loaded to a database, but we would like to make an ad-hoc analysis possible. There is always some delay for each reload of the QlikView sheet.

Regards

Christian

[Anonymous]

I see - you get a list that doesn't have any usable criteria.
You're right - there is no simple solution. At least I don't see it. You have to keep your complex way, or to reload.