topic Re: Upload data in a QVW on Access Point? in QlikView

Upload data in a QVW on Access Point?

dmohanty — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

Suppose my QVW is available on Access Point. Now I want to give access to my Users to upload few values to a List Box. For example, there is a List Box called Country with values USA,INDIA,CHINA. Now one user wants to add few more values ex: JAPAN, AUSTRALIA to the Country List Box so that other users can Export the latest data. This task should be User oriented. User should upload the latest data to the QVW file without the help of Developer.

Is it by any chance possible from Access Point (IE Plugin/AJAX), without opening the QVW file in developer mode?

If not, are there any other methodologies without touching the original QVW file, like any Input Box usage, or use of Excel Data etc etc.

Please cite some suggestions.

Regards!!!.

Re: Upload data in a QVW on Access Point?

jonasheisterkam — Mon, 11 Nov 2013 18:56:48 GMT

If the values are connected to the data model, the best way is to enter the data in a source and trigger a reload. There are some extensions in the market.

So the user fill a input field and press a button, then the data is written into a source like a database or flatfile and a edx task will trigger a reload of the document.

If the connection to the data model is very simpel and only a few records you can write in a database and use direct discovery to display.

Direct input records are only for one user i thing and will removed in the next reload.

Re: Upload data in a QVW on Access Point?

dmohanty — Mon, 11 Nov 2013 19:09:06 GMT

Thanks Jonas.

Can you please elaborate/ show me an example?

My requirement is pretty simpler though: My QVW has a single List box (nothing else) and data is coming from an Excel Sheet/single table. QVW is being triggered in QMC.

Suppose the User has no clue about the Excel Sheet and its location and he is really not bothered about it. He just wants to upload the latest values directly in front end of QVW from Access Point, without placing it in table/excel.

Is it possible?

Re: Re: Upload data in a QVW on Access Point?

Anonymous — Mon, 11 Nov 2013 19:14:34 GMT

I suggest stepping back here and pondering the KISS [Keep It Simple ........] principle.

As Wikipedia says:

The KISS principle states that most systems work best if they are kept simple rather than made complex; therefore simplicity should be a key goal in design and unnecessary complexity should be avoided.

Best Regards, Bill

Re: Upload data in a QVW on Access Point?

jonasheisterkam — Mon, 11 Nov 2013 20:07:06 GMT

With EDX Task it is not so easy to show. If you will update the xls you can use a macro with server side export. You can find help to build a macro in the COM API Guide, in the sdk section. There is a example for nearly all qv-vbs commands. For the beginning you can build a document update task, witch runs every minute with a addload and if there is nothing new you can let it fail.

Re: Upload data in a QVW on Access Point?

Anonymous — Mon, 11 Nov 2013 20:33:31 GMT

If you literally have only one list box (Country) and nothing else, you can create an input box with a variable vCountry, and change your list box to Expression like this:

=if((vCountry & Country)=vCountry, vCountry, Replace(Country,vCountry, null()))

Nothing to upload. It will list all values from the field Country plus the value in the input box, which could be another Country.

Frankly, it doesn't make much sense to me, but meets the requirement as described... I guess you want to clarify your requirements.

Regards,

Michael

Re: Re: Upload data in a QVW on Access Point?

jonasheisterkam — Mon, 11 Nov 2013 20:48:41 GMT

Here is a example for Dynamic Update (insert) and serversideexport. In a reload/addload you must load the file created in the macro.

Re: Upload data in a QVW on Access Point?

jonasheisterkam — Mon, 11 Nov 2013 22:45:40 GMT

Here is a solution, to trigger a reload.

Triggering an EDX Task from the Ajax Client

Re: Upload data in a QVW on Access Point?

dmohanty — Tue, 12 Nov 2013 05:26:45 GMT

Hi Michael,

Thanks for this help.

In fact, when I add a value of Country in the Input Box, its get added to the List Box. But when I add a new value to the input box afterwards, the previously entered value goes away, where I want that to stay too in the List Box (the values should keep on appending)!

Is that be possible?

Re: Upload data in a QVW on Access Point?

dmohanty — Tue, 12 Nov 2013 05:29:27 GMT

Hi Jonas,

Thanks for these help. I will try to work on these.

However could you please let me know how to operate the QVW file you have sent? Most of the times file gets hung, when I click on the button.

Regards!

Re: Upload data in a QVW on Access Point?

jonasheisterkam — Tue, 12 Nov 2013 06:07:20 GMT

You must change the Folder in the macro, if you don't have it or not enough rights on it. I don't know if you must set the options again to allow unsave macros and give them right to enter the hdd. If the first Action Dynamic Update not being pushed there is some option on Document Properties -> Server i think.

Re: Upload data in a QVW on Access Point?

dmohanty — Tue, 12 Nov 2013 07:41:37 GMT

Hey Jason,

Thanks a Lot.

Got the logic from your help. Now one by one values are getting added to the List Box.

But this is happening only in Desktop Mode without reloading even. Perhaps the Macro is not functioning when the Button is clicked in the docuemnt opened from Access Point. Could you please suggest? Any regular reload required?

Could you please also let me know how to remove those inserted values from the List Box?

Re: Upload data in a QVW on Access Point?

jonasheisterkam — Tue, 12 Nov 2013 07:54:57 GMT

Use it like the insert action. It will delete if you select one value in Dim1 and execute the action.

='DELETE FROM Transactions where Dim1='&chr(39)&only(Dim1)&chr(39)&'

Have you allow unsave Macro on server? My test on a server was positive.

Re: Upload data in a QVW on Access Point?

dmohanty — Tue, 12 Nov 2013 09:49:25 GMT

Yes Jonas,

Allow Unsafe Macros is enabled on Server. Still it didnt worked.

Re: Upload data in a QVW on Access Point?

jonasheisterkam — Tue, 12 Nov 2013 10:09:53 GMT

Has youre server user write rights in the export folder? The folder is on the server not local (ServerSideExport).

The Server i used has this Setup Server Security:

Allow dynamic data update

Allow macro execution on server

Allow unsafe macro execution on server

Under Documents all options are allow

If you copy it in a other document, you must change document settings with QV-Client for Server and the macro options.

Re: Upload data in a QVW on Access Point?

dmohanty — Tue, 12 Nov 2013 13:42:20 GMT

Jonas,

I have all the settings enabled as you have said. Also export location is on server.

Still clueless why the Macro (Button) not working on Access Point.

Re: Re: Upload data in a QVW on Access Point?

Anonymous — Tue, 12 Nov 2013 14:31:48 GMT

My "solution" is for one value. Anything else should involve reload, which is either EDX as Jonas Heisterkamp recommends, or frequently running scheduled reload, if possible.

You still can use a variable to enter additional value, reload, change variable value, reload, etc. See attached example.

Regards,

Michael

Re: Upload data in a QVW on Access Point?

dmohanty — Tue, 12 Nov 2013 15:00:06 GMT

Thanks a lot Michael.

It helped me a lot in learning more.

Could you please also help me out in the below thread?

http://community.qlik.com/thread/98718

Regards!!