topic Re: Hi i would like to pass filter values as parameters to the load editor . based on the filters valuesreport should fetch data. in Management & Governance

Hi i would like to pass filter values as parameters to the load editor . based on the filters valuesreport should fetch data.

Fri, 02 Apr 2021 07:37:29 GMT

Hi ,

I like to connect filter values as paramters to the sql script .

Ex : i have a date as filter . I need to choose only one filter instead of multi select .

and i like to pass that parameter in sql script as

select case($(parameter )) > 30 then some_calculations else end

from table

is this scenario is applicable in qliksense . do we any alternative for dynamic value passing mechanism at runtime .

REgards,

Anuradha

Re: Hi i would like to pass filter values as parameters to the load editor . based on the filters valuesreport should fetch data.

lakshmikandh — Mon, 24 Oct 2016 07:24:04 GMT

Add your variables in the text file and include that in load script,

$(include=lib://Desktop/ExternalVariables.txt);

tabCalendar:

LOAD *,

$(vParameter1) as v1,

$(vParameter2) as v2,

Day(Date) as Day,

WeekDay(Date) as WeekDay,

Week(Date) as Week,

WeekName(Date) as WeekName,

Month(Date) as Month,

MonthName(Date) as MonthName,

QuarterName(Date) as QuarterName,

Year(Date) as Year,

WeekYear(Date) as WeekYear;

LOAD Date(Date#('01/01/2005', 'MM/DD/YYYY')+IterNo()-1) as Date

AutoGenerate 1

While Date#('01/01/2005', 'MM/DD/YYYY')+IterNo()-1 <= Today();

This will include your external variables.

Re: Hi i would like to pass filter values as parameters to the load editor . based on the filters valuesreport should fetch data.

Mon, 24 Oct 2016 12:44:36 GMT

Thanks For the Response Lakshmikanth .

Please look into below points what i have done till now and what is my exact requirement .

1) Created dashboard .

2) Added Many filters to the dashboard .

3) among all the filters , users choosing particuar filter (In my case i have to choose date as filter).

4) chosen date should pass as parameters to the Query . then Dynamically values should change .

Here I'm doing some calculation based on the Input parameters passed .

Ex : select case when datediff(vParameter,date) > 30 then 1 else 0 end from table_name

here my vParameter should take chosen date as parameter to the query .

The example given by you has static values defined in it . Please let me know how to pass values dynamically .

Regards,
Anuradha

Re: Hi i would like to pass filter values as parameters to the load editor . based on the filters valuesreport should fetch data.

lakshmikandh — Mon, 24 Oct 2016 13:17:49 GMT

Hi Anu,

You can do this in expression itself you dont need to do this calculation in Load script.

Create a variable and using the extension Re: Is there a way to add Date Picker Calendar object in Qlik Sense?

or this GitHub - erikwett/qsVariable: Variable extension for Qlik Sense

assign the respective date to the variable and use your variable in the expression to calculate.

on selection the values will reflect dynamically.

Thanks,

Lakhsmikandh

Re: Hi i would like to pass filter values as parameters to the load editor . based on the filters valuesreport should fetch data.

Tue, 25 Oct 2016 04:59:41 GMT

Thanks Lakshmi .

While opening variable extension from qlisksense desktop Getting below error .

variable is incomplete and cannot be opened or duplicated (wbfolder.wbl )is missing

Please help me out . 🙂

Re: Hi i would like to pass filter values as parameters to the load editor . based on the filters valuesreport should fetch data.

Tue, 25 Oct 2016 05:38:33 GMT

i did changes to the variable extension given by creating wbl file . Still getting error as visualization not found on the server .

for the first solution of date picker i need to have access for Qwidget . please provide me a access .

Thanks ,

Anuradha

Re: Hi i would like to pass filter values as parameters to the load editor . based on the filters valuesreport should fetch data.

lakshmikandh — Wed, 26 Oct 2016 05:58:48 GMT

Which version of QS desktop you are using ?

Re: Hi i would like to pass filter values as parameters to the load editor . based on the filters valuesreport should fetch data.

Wed, 26 Oct 2016 06:12:40 GMT

HI ,

It's 3.1 SR1 .

It will be good if im getting access to a 3.1 SR1

Re: Hi i would like to pass filter values as parameters to the load editor . based on the filters valuesreport should fetch data.

Wed, 26 Oct 2016 06:14:45 GMT

It will be helpful if i'm getting access to date picker object