Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

dmohanty
Valued Contributor

Upload data in a QVW on Access Point?

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!!!.

17 Replies
jonasheisterkam
Contributor III

Re: Upload data in a QVW on Access Point?

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.

dmohanty
Valued Contributor

Re: Upload data in a QVW on Access Point?

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?

Hi

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


jonasheisterkam
Contributor III

Re: Upload data in a QVW on Access Point?

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.

mov
Esteemed Contributor III

Re: Upload data in a QVW on Access Point?

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


jonasheisterkam
Contributor III

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

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

jonasheisterkam
Contributor III

Re: Upload data in a QVW on Access Point?

Here is a solution, to trigger a reload.

Triggering an EDX Task from the Ajax Client

dmohanty
Valued Contributor

Re: Upload data in a QVW on Access Point?

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?

dmohanty
Valued Contributor

Re: Upload data in a QVW on Access Point?

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!

Community Browser