Reload based on selection

[#1]

Hi,

I have a requirement where I need to build a sheet which allows:

1) selection of two dates

2) based on the dates we need to retrieve an associated value

3) the associated value will be passed to a variable

4) the variable is used in the load script

5) reload the data to show updated results

Please let me know if this is possible?

thanks

[tresesco]

See the screenshots attached.

[#3]

Thanks tresesco! That does help but I am still not able to figure the complete puzzle.

I still need to get the value associated to the two dates. Sorry for being too naive but I am just one week old in Qlikview terms.

[tresesco]

In that case, you have to similarly deal with two variables and use them in the script, like:

Load

     *

where Date>=$(vStartDate) and Date<= $(vEndDate);

[hannan_t]

In my opinion, use an expression in load script variable e.g

vLoadScript = Sum({<Date={'$(vLastday)'}, Date={'$(vToday)'}>}Amont)

Make variables for the dates you want to select and pass it to your expression through set analysis.

[#6 · Accepted solution]

I was able to solve this with Manish's help ....post can be found here http://community.qlik.com/thread/124995