Reload Script using selected date

[k_burata]

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

[swuehl]

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.

[simospa · Accepted solution]

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.

[k_burata]

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?

[simospa]

Hi,

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

S.