Hello,
Just downloaded QlikView for testing some front end reporting tools. So I'm just new an do some try and error.
Now I have a question about Variables. I've made some SQL queries in the main Script window, now I want to use one result as a Variable for an upcoming Query.
So I made a Connection to A SQL server, made some queries, one is "LOAD invdat;". The next Query needs the output of this one. So I made:
LOAD LiefDatum;
SQL SELECT distingt LiefDatum
FROM sqldbdepot.dbo."dep_ebp"
where LiefDatum >= $(invdat) ;
Wanted to use the invdat as Variable, but that's not working the way I thought. So I need to declare that Variable somehow and put the output of the first Query in that Variable. But how?
