topic Re: Reload Script using selected date in QlikView

Reload Script using selected date

k_burata — Wed, 16 Dec 2015 05:36:33 GMT

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 — Wed, 16 Dec 2015 10:51:06 GMT

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 — Wed, 16 Dec 2015 11:02:17 GMT

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.

k_burata — Thu, 17 Dec 2015 03:17:25 GMT

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 — Thu, 17 Dec 2015 13:41:56 GMT

Hi,

to reload from Access Point you need use EDX.

If you have problem please open a new thread dedicated to that issue