Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
At the end of a succesful script run, press Ctrl-T to open the Table Viewer. There will be at least one table with at least one field. If you do not assign names, QlikView will.