Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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
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 . 🙂
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
Which version of QS desktop you are using ?
HI ,
It's 3.1 SR1 .
It will be good if im getting access to a 3.1 SR1
It will be helpful if i'm getting access to date picker object