Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've got a .qvd and it pulls the data from a spreadsheet on my computer (it's actually on my network drive here at work). If I try to send someone the .qvd, there is never any data in it (I'm guessing it's because the data is stored on my computer/network drive that they don't have access to). Anyone know how to fix this?
Thanks.
If there is no data in your qvd, then it must not be the correct qvd data are stored in.
To be sure, check in the qvw file if there is a STORE function in your script.
If there is a STORE function, then check the QVD file mentionned inside.
If this is the correct QVD, that means that either there is no data to store OR for any reason the QVD could not be rebuilt on the network.
Regards,
Sébastien
Hello,
I'm likely missing something here: what you have is a QVW file that pulls data from a spreadsheet and stores it into a QVD file. Then you can send either the QVD file to be opened by another QVW document or the QVW document itself, with the data loaded. Is that what you mean?
Regards.
My mistake it's actually a .qvw that I'm trying to send, not a .qvd. I've been working strictly in a server where smart IT people handle the script and things like that so this is pretty new to me. I didn't know there was a "store" function or anything like that so I should probably look into that. Basically what I've got here is a .qvw that gets it's data from an Excel spreadsheet and I want to be able to say, send this .qvw to my boss and let them look at it as well and I'm not sure how to do that.
Appreciate your help.
By default qvw files (which are the dashboards) store the data inside itself.
So if you send a qvw file to someone else who have QlikView installed, you can share the dashboard ( except if security access was set up in your document).
QVD files are specific QlikView files that can be created in order to have table warehouses and prevent too many database loads.
It seems that what you want to do is sharing your dashboard with someoneelse, so normally if you send the qvw file, or you keep it in a shared folder, that should work...
If it is not working, that coul be because of security reasons, data not recorded in your qvw file ( setting that is not checked by default)...
Rgds,
Sébastien
trent.jones wrote:Basically what I've got here is a .qvw that gets it's data from an Excel spreadsheet and I want to be able to say, send this .qvw to my boss and let them look at it as well and I'm not sure how to do that.
Basically, what the script does (or what it is intended to) is loading data into a document that will render it in the form of charts, and different graphic objects and tables. So when anything is loaded into a QVW file, the data, unless reduced manually, is kept in the file.
So one way to do that is, actually, attach the QVW file and send by email. Both sender and addressee must have licenses in order to open the file without trouble.
What the QlikView Server does, anyway, is managing documents and permissions in a centralized place and let the users access them.
Going back to your original question, if the problem is that the file is empty, there may be many reasons for that to happen: a section access (document-level security), the data has been reduced manually, some scripted reload process fails... Knowing the exact error would be fine to start finding out where the problem is.
Hope this makes some sense.
Do you know where the setting is for recording the data in the .qvw is?
Sorry for the mistake:
Data are stored in your Qvw file after reload.
As Miguel advised you, you should :
First reload the document on your computer and check if it work.
If it work, then check that you see the correct charts and numbers in your dashboard.
Save your Qvw file
Share it with the other person.
If you see data and not the other person, it seems it is a "Section access" that prevent the other users to have access to the data.
Or Reduction is activated in Document properties\ Opening tab \ Reduce Data check box...
I hope it help too.
Regards,
Sébastien