topic Can we upload QVD / Excel from folder on selection in QlikView

Can we upload QVD / Excel from folder on selection

Mon, 14 Feb 2011 13:57:22 GMT

Hi All,

Can we upload any QVD , Excel or CSV file from some other external folder to the final application.

Selecting all the data files from that folder is possible and done ........

NOw the problem is when end user want to select only selected QVD or CSV from folder on the fly how it will be done.

He does not want all the qvd to be uploded..... please reply it urgent

Can we upload QVD / Excel from folder on selection

rothtd — Mon, 14 Feb 2011 15:24:38 GMT

Instead of selecting one QVD/Excel Document and attempting to load it in real-time - could you load all QVDs/Excel Docs in a folder and then filter them out in real time? You state that you are already loading all files in a given directory, can you provide a way for the user to remove the files they do not wish to see (i.e. only looking at the one they wish to see).

I received this same question from one of our QlikView developers at my company. It seems that QlikView (by design) isn't good at dynamically loading various pieces of data in real-time (your request). But, I bet you could accomplish the same result by loading all data (assuming it's small enough), then using QlikView to filter out the non-needed data in real-time.

Can we upload QVD / Excel from folder on selection

Tue, 15 Feb 2011 09:09:52 GMT

HI Trevor,

Actually My client do not want to give data table access to end user. So its not possible that he can manually remove the QVD / Excel from the folder. I have allready suggested this but it was rejected.

Secondly we are working on very huge data. On every date we have 30 million rows of data in tables. and QVD present will be for current month and previous month in that Folder.

Requirement is user can select the Day on the fly i:e real time. and data get uploaded on the front end.

Can we upload QVD / Excel from folder on selection

Tue, 15 Feb 2011 09:27:16 GMT

HI all,

Plzzz Any Inputs for the above problem ????

Can we upload QVD / Excel from folder on selection

rothtd — Tue, 15 Feb 2011 15:01:31 GMT

I wasn't talking about the end-user physically removing the Excel files from a folder; I was referring to the end user removing from the QlikView data.

I was envisioning something like the following:

Can we upload QVD / Excel from folder on selection

rothtd — Tue, 15 Feb 2011 15:19:28 GMT

I have two other ideas for you to consider:

1) Use the 'Real-Time Data' option with QV 9.

a. http://www.qlik.com/us/company/press-room/press-releases/2009/0610-qlikview-9-sets-new-bi-standard

b. Check your QV 9 Manual

2) Create a variable that the user can set (variable holds the path to desired QVD/Spreadsheet) and allow the user to refresh the QV app on demand.

a. I had success using a button/macro on the GUI to allow a end user to refresh a QlikView application on demand (assuming they were in the correct security group).

Re: Can we upload QVD / Excel from folder on selection

balasundaram — Wed, 08 Jul 2015 09:43:47 GMT

Hi Ashwin,

Did you find solution for this?.

If you found kindly let me know

Thanks

Balasundaram