Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
rendiyan
Partner - Creator
Partner - Creator

passing parameter from qliksense to web url

Halo Community,

So the background story is that in my company we have two servers that handle qliksense  for dashboard and jasper for detail reporting.

Often time, when users analyze from qliksense dashboard with their selection, they also have to re-select the parameter in jasper report in order to get the detail data.

They have to do this everytime to get the detail data. And sometimes they get different data because they input different parameter value.

In order to resolve the issue, they request for qliksense to able to passing the parameter to jasper report.

 

below is an example of report that we use :

1.png

as picture above, user have to select one or more clients in order to show the report.

 

and below is the example for qliksense :

2.PNG

 

instead of selecting filter in each system (qliksense and jasper), can we pass the parameter value (in this case is client filter) that we've selected before and send value parameter to jasper to run the report?

 

Thank You,

Best Regards

Labels (2)
3 Replies
Simon_Astakhov
Partner - Contributor III
Partner - Contributor III

When you open URL of Jasper make it calculated, for example:

='https://url/page?users=' & concat(distinct [client], ',')

It will return https://url/page?users=1,2,3,4 selected or possible [clients].

Which parameter use you can ask from Jasper team.

Simon_Astakhov
Partner - Contributor III
Partner - Contributor III

Another case is use ='https://url/page?user=' & concat(distinct [client], '&user=')

to get URL like https://url/page?user=1&user=2&user=3&user=4

rendiyan
Partner - Creator
Partner - Creator
Author

Hi Simon,

unfortunately, for the jasper report, it's server side processing.

So no matter what we do in the report (processed / not processed), there's nothing happen with the url.

here's the url with some mark :

https://[URL]/jasperserver/flow.html?_flowId=viewReportFlow&_flowId=viewReportFlow&ParentFolderUri=%2F
[FOLDER1]%2F[FOLDER2]%2F[FOLDER3]%2F[FOLDER4]&reportUnit=%2F[FOLDER1]%2F[FOLDER2]%2F[FOLDER3]%2F[FOLDER4]%2F[REPORT NAME]&standAlone=true

 

Best Regards