Discussion Board for collaboration on QlikView Scripting.
I need to reload my data based on the date selected on the Calendar Object.
Created a button and put in action to set the variable = selected date and did a reload. Problem is doesn't seem to work. Am I missing something?
IF ([DateFrom] < $(vSelectedDate) AND [DateTo] > $(vSelectedDate), 'T', 'F') AS Status
Set Variable: vSelectedDate value = CalendarDateField
Go to Solution.
try to see my attachment and tell me if it's different from your.
You'd adapt the date format in order to have a match with your script.
If you can post a snippet of code or your application.
Let me know.
How does your variable looks like when you put it in an input box?
If it's a number and [DateFrom] and [DateTo] are interpreted as dates, it should work.
If it's not a number, but the formatted date text, but in your standard date format, try enclosing the variable in single quotes:
IF ([DateFrom] < '$(vSelectedDate)' AND [DateTo] > '$(vSelectedDate)', 'T', 'F') AS Status
As you see, it's probably a matter of value formatting and interpreting.
Next challenge for me is to reload it in Acess Point.
I need to reload data using date selected in Access Point.
How do I do about this one?
to reload from Access Point you need use EDX.
Take a look here: Using EDX in QlikView 11 - basic example
Qlikview 11 EDX
If you have problem please open a new thread dedicated to that issue