Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
chaitanyahublik
New Contributor

Hyperlink to SAP BO from dimension

Hi ,

I have a chart table with dims as Country Product and key figure Revenue. I also have few multi box for selection like Year and Quarter.

Now suppose I have selected year as 2016 and quarter as 1 from multi box. Now I have all the countries with products and revenue of 2016 Q1.

  Now my requirement is when I click on any revenue figure, I should be directed to detailed report of SAP Business Objects with all the parameters (Year , Qtr , Country and product of selected line) .

Is this possible? I am able to open a SAP BO report by using expression as URL but not able to pass parameter. Link is something as below -

Product&'<url>http://bodev.starcusert.com:8080/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=AfebEl78HLRCnytrGw...)  

Here I need to pass multiple parameters. Please help!

Thanks,

Chaitanya