Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!.
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.
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?
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.
Yes Jonas,
Allow Unsafe Macros is enabled on Server. Still it didnt worked.
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.
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.
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
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!!