Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
pkelly
Specialist
Specialist

Is this posible...?

Background....

Our users access QlikView reports using the Internet Explorer plugin.

We have a QlikView report with some basic sales data by customer say showing the last 12 months.

The Task which I have been given...

From within the QlikView report (which the user is opening via Internet Explorer), allow the user to open / point to a MS Excel spreadsheet which will contain a list of customer codes.

When this spreadsheet has opened, either reload the report or apply a filter based on these accounts.

Questions...

1)  Does this sound feasible using Internet Explorer or are we expecting too much?

2)  If it is, can someone please give me a few pointers to get me started?

1 Solution

Accepted Solutions
bnichol
Specialist
Specialist

This sounds complicated. 

Alternatively, I'd suggest giving the users the ability to paste a list of customer codes and have that list act as the filter.

Here's a community topic that discusses how that can be accomplished... http://community.qlik.com/message/72460#72460

Good luck,

B

View solution in original post

3 Replies
danielrozental
Master II
Master II

Sounds feasible through a macro, first find the vbscript to start a "open file dialog", then do a vbscript open excel file, read cells from the file and apply the filter with the field, select methods.

bnichol
Specialist
Specialist

This sounds complicated. 

Alternatively, I'd suggest giving the users the ability to paste a list of customer codes and have that list act as the filter.

Here's a community topic that discusses how that can be accomplished... http://community.qlik.com/message/72460#72460

Good luck,

B

View solution in original post

pkelly
Specialist
Specialist
Author

Thanks B

I have used the Macro solution and I am almost there.

The issue that I have is that accessing the report via QlikView application and Internet Explorer work differently.

Let me explain...

When I paste the list into the input box in the QlikView application it pastes like this...

A B C

I therefore replace chr(32) in the macro.

However, in Internet explorer it pastes as...

A

B

C

I therefore need to replace chr(10) in the macro...

Unfortunately I will have users accessing from both.

How do I determine whether I need to replace chr(32) or chr(10)

chr(32) = Space

chr(10) = carriage return

Example of macro I am using is from link "B" provided...

Sub FilterSpace

set v = ActiveDocument.Variables("vCustomerSpace")
strVariable = v.GetContent.String

vOptions = "'" & replace(strVariable, chr(32), "','") & "'"
Set C=ActiveDocument.Getfield("cus_Code")
C.Select "=match(cus_Code," & vOptions & ")"

End Sub