topic Re: Load straight table data into qvw in QlikView

Load straight table data into qvw

jzimolong — Thu, 13 Jun 2013 17:10:27 GMT

Not sure if this is possible, but figured I'd ask. I have a .qvw with a straight table that has many expressions. Since I'm unable to click on these cells to filter the table down, I export it to Excel and distribute accordingly.

What I'd like to do is use the contents of this straight table (unfiltered) as the data in another .qvw, were I could then setup list boxes, etc., to slice and create visualizations, etc.

Is his even possible?

Re: Load straight table data into qvw

Gysbert_Wassenaar — Thu, 13 Jun 2013 17:13:43 GMT

You can export the table data to excel (or a qvd or text file) and load the excel file in another qvw document. You can't do it directly. Right click the table, choose Export... and enter a filename and choose a data format.

Re: Load straight table data into qvw

jzimolong — Thu, 13 Jun 2013 17:23:59 GMT

Thank you Gysbert, I exported this to a .qvd and it works well. I created a 2nd .qvw to import from the .qvd.

When I need to get updated data, I would first reload the .qvw with the straight table, then reload the .qvd? I would like to automate this so I can simply open the 2nd .qvw (which will pull from the .qvd) and reload to see updated report data.

Re: Load straight table data into qvw

jzimolong — Thu, 13 Jun 2013 19:30:47 GMT

Finally understand how the .qvd files work. It was my first time using them, so sorry for the novice questions. Anyway, I now have a button on my main .qvw that will refresh the .qvd file. From there, I can simply open my 2nd .qvw and reload the data.