Add your variables in the text file and include that in load script,
$(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
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 .
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?
assign the respective date to the variable and use your variable in the expression to calculate.
on selection the values will reflect dynamically.