Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

Labels (1)
  • SaaS

8 Replies
lakshmikandh
Specialist II
Specialist II

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.

Not applicable
Author

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

lakshmikandh
Specialist II
Specialist II

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

Not applicable
Author

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 . 🙂

Not applicable
Author

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

lakshmikandh
Specialist II
Specialist II

Which version of QS desktop you are using ?

Not applicable
Author

HI ,

It's 3.1 SR1 .

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

Not applicable
Author

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