Converting SQL results (typically excel) to QVD to be used in QlikV
I need to run a SQL script on an external database and then translate these results into .qvd to use in QlikView. I have searched the community to understand how to do this. There is lots and lots of information out there and I am getting a little confused. Does anyone have or know of a demo I could watch to better understand how to run the full process?
thanks Fernando. I was running the script in a separate SQL tool called Razor. So are you saying I don't need to do this? I can be using SQL native that is provided within QlikView? If yes, where do I go to use SQL native within QlikView please?
If you have installed qlikview, go to edit script by pressing Ctrl + E to access Edit script window. Then write your sql and use store command like above and reload the dashboard pressing Ctrl + R. once the reload is completed, the qvd will be created and it will be found in the same path where your qvw file is saved.