topic Re: passing parameter from qliksense to web url in Integration, Extension & APIs

passing parameter from qliksense to web url

rendiyan — Sat, 16 Nov 2024 05:23:52 GMT

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 :

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

and below is the example for qliksense :

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

Re: passing parameter from qliksense to web url

Simon_Astakhov — Wed, 03 Jul 2019 12:18:41 GMT

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.

Re: passing parameter from qliksense to web url

Simon_Astakhov — Wed, 03 Jul 2019 12:24:01 GMT

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

Re: passing parameter from qliksense to web url

rendiyan — Thu, 04 Jul 2019 03:43:20 GMT

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