topic Re: How to pass input parameters from Qlik Sense to limit the data fetched from database? in Visualization and Usability

How to pass input parameters from Qlik Sense to limit the data fetched from database?

SandeepBiswas — Sat, 16 Nov 2024 21:21:45 GMT

We have a requirement where the user will provide a date range as input. The database contains millions of records but based on the date range chosen by the user, the query should narrow the resultset to be brought back. We have implemented date picker to select the range. Now how do we pass these dates to the SQL query from Qlik Sense?

An example query may be,

SELECT POLICY_NUM, POLICY_HOLDER_NAME FROM POLICY WHERE ISSUE DATE BETWEEN @START_DATE and @END_DATE

Re: How to pass input parameters from Qlik Sense to limit the data fetched from database?

Channa — Sun, 24 Feb 2019 08:04:36 GMT

u can try with stored procedure

https://www.youtube.com/watch?v=o1uBAMrVyFE

Re: How to pass input parameters from Qlik Sense to limit the data fetched from database?

SandeepBiswas — Mon, 25 Feb 2019 12:28:47 GMT

This video is about Qlik View. We are using Qlik Sense.

Re: How to pass input parameters from Qlik Sense to limit the data fetched from database?

rajreddys — Fri, 19 Jun 2020 01:45:03 GMT

Hello, did you find a solution for this, I have a similar use case of passing parameters to a where clause in oracle.

Re: How to pass input parameters from Qlik Sense to limit the data fetched from database?

JustinDallas — Fri, 19 Jun 2020 13:43:31 GMT

When you create your SQL Statement, you append to it the parameters of your WHERE clause. Or you can create a sproc, and then add those parameters to the SQL Statement

Re: How to pass input parameters from Qlik Sense to limit the data fetched from database?

rajreddys — Mon, 22 Jun 2020 11:43:34 GMT

I am using the following query with input parameters. I see the values are replaced with the parameter values in the query. However when loading the data, there are no records loaded. If I replace the parameter values with actual values the data would be loaded. Please suggest if there is anything I am missing.

LIB CONNECT TO 'TEST';

Set v_gl_segment_name = 'Activity Code';
Set v_gl_segment_value = '10';
DIRECT QUERY DIMENSION
TEST.COMPANY,
TEST1.ACCOUNT,
MEASURE
SUM(TEST.AMOUNT) AS AMOUNT,
1 AS LINE_CT
FROM TEST ,
TEST1,
WHERE 1=1 AND
TEST.SEGMENT_NAME='$(v_gl_segment_name)' AND TEST1.CREDIT_CODE='$(v_gl_segment_value)'