topic How can users upload tables (XLS) for filtering? in QlikView

How can users upload tables (XLS) for filtering?

Wed, 04 Nov 2009 05:56:37 GMT

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?

How can users upload tables (XLS) for filtering?

Wed, 04 Nov 2009 06:31:56 GMT

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

How can users upload tables (XLS) for filtering?

Fri, 06 Nov 2009 21:58:22 GMT

Hi dragonauta,

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

Do you have any example?

Thanks

How can users upload tables (XLS) for filtering?

Fri, 06 Nov 2009 22:52:30 GMT

@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...

How can users upload tables (XLS) for filtering?

Mon, 09 Nov 2009 14:33:10 GMT

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.