Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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?
script:
LOAD
IF ([DateFrom] < $(vSelectedDate) AND [DateTo] > $(vSelectedDate), 'T', 'F') AS Status
Resident Table;
Button Action
Set Variable: vSelectedDate value = CalendarDateField
Reload
Thanks
Hi Kim,
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.
S.
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:
LOAD
IF ([DateFrom] < '$(vSelectedDate)' AND [DateTo] > '$(vSelectedDate)', 'T', 'F') AS Status
Resident Table;
As you see, it's probably a matter of value formatting and interpreting.
Hi Kim,
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.
S.
Thanks Simone.
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?
Hi,
to reload from Access Point you need use EDX.
Take a look here: Using EDX in QlikView 11 - basic example
If you have problem please open a new thread dedicated to that issue
S.