Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
k_burata
Creator
Creator

Reload Script using selected date

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

1 Solution

Accepted Solutions
simospa
Partner - Specialist
Partner - Specialist

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.

View solution in original post

4 Replies
swuehl
MVP
MVP

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
Partner - Specialist
Partner - Specialist

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
Creator
Creator
Author

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
Partner - Specialist
Partner - Specialist

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.