Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See the screenshots attached.
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.
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);
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.
I was able to solve this with Manish's help ....post can be found here http://community.qlik.com/thread/124995