3 Replies Latest reply: Aug 24, 2011 4:54 AM by Paul Kelly RSS

    Is this posible...?

    Paul Kelly

      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?

        • Is this posible...?
          Daniel Rozental

          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.

          • Is this posible...?
            Brent Nichol

            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

              • Is this posible...?
                Paul Kelly

                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