How can users upload tables (XLS) for filtering?

[#1]

I have a requierment where a user needs to upload a XLS of product codes so he can apply filters to a QVW. There's no pattern or criteria where I can anticipate this filter in the load script, so I need a solution where a user can upload X amount of values to a QVW. Anyone have any suggestions?

[#2]

Never mind, I solved it with the following script

Sub Filter
 arrFilter = split(ActiveDocument.Variables("varFilter").GetContent.String,",")

 for x = 0 to ubound(arrFilter)
 ActiveDocument.Fields("FieldToFilter").ToggleSelect arrFilter(x)
 next
End Sub

[#3]

Hi dragonauta,

I have the same problem, but i don't understand how you solve the problem.

Do you have any example?

Thanks

[#4]

@dragonauta - I am not clear about what is it you are trying to do...you can load an excel in the doc, and then use that variable name in your script, cant you?

what ur doing now will also work though...

[#5]

Hi,

Thanks for your support and sorry for my bad English.

Sorry for my bad English.

I have in Qlikview 150,000 customers. By filter I can display the sales for individual customers. Now I would have I the individual customer in filter set and view the sales will be like 500 customers who are in an Excel file .

My question is: if I give this code in script, how can I load the Excel file in the filter with the 500 customers?

What do you mean "load excel in doc"? You mean I load excel with the 500 customer in script and combine with the total Customer in script and use the variable?

I thought I can load the excel file (500 customer) as filter in the qlikview model and not in script.

Thanks.