Update + Store

waldemar_doling — Thu, 05 Jul 2012 10:04:53 GMT

Hi guys,

I've following problem:

I want to give an opportunity for users which use my dashboat via browser to change data and to save these changes.

Is it generally possible?

I tried this one:

1. I load my Table from existed qvd

2. Then User can modify this data (using Buttons with Action: Dynamic Update - SQL Commands)

3. Finally user has to decide if he wants to store the data (SAVE - Run Partial Script) or abort the changes (RESET - Run Script)

In Script:

 let Table='mytab';

//vReset = true = Button Reset (Änderungen werden verworfen)
//vReset = false = Button Save (Änderungen werden gespeichert)


IF IsPartialReload() THEN

      IF '$(vReset)' = 'false' THEN
      
      // Speichern der Tabelle in QVD
      store [$(Table)] into [$(Table).qvd];
     
      ENDIF
       
 ENDIF

[$(Table)]:
LOAD
* 
FROM
[$(Table).qvd]
(qvd)
;

If I do it in qlikview application - it works, but if I do it in browser it does't work.

Does somebody have an idee for me? Thanks in advance!

topic Update + Store in QlikView

Update + Store