Reloading different QVWs in continuation

[kamal_sanguri]

Hi All,

I am new to Qlikview and working on project where I have multiple QVWs. L1 which loads the raw data in and converts it into QVDs. L2 which loads data from QVD generated by L1 and transforms the data (joining multiple tables and filtering unwanted data) and creates QVDs and at Last L4 which brings data into qlikview from QVDs created by L2 and represent the data in graphical format (Dashboards).

Now the challenge is I have to load all 3 QVWs one by one. First I open and run L1 then L2 and then L4. So just wandering if there is any way I can place a button on L4 which will load L1 so that it pull data from and convert that into QVDs then Load L2 and then L4.

Any help would be greatly appreciated.

Thanks in advance.

[maxgro]

- it seems you haven't a qlikview server; in a server you can schedule dependent reloads

- for qlikview desktop you can use a dos batch

SET DISK=E

SET WORKDIR="E:\Projects\........"

SET QVDIR="C:\Program Files\QlikView\QV.exe"

%DISK%:

cd %WORKDIR%

%QVDIR% /r "T_00_CALENDARIO.qvw"

%QVDIR% /r "T_01_ARTICOLO.qvw"

%QVDIR% /r "T_02_ANAGRAFICHE.qvw"

.........

- or you can try with a button with more launch actions

[Anonymous]

Hello.

You can try creating a button with 3 actions:

1. External/Launch: "C:\Program Files\QlikView\qv.exe" /r L1.qvw

2. External/Launch: "C:\Program Files\QlikView\qv.exe" /r L2.qvw

3. External/Run Script

If you are using QlikView Server, you can schedule L2 and L4 "On Event of Anothe Task", triggering them in sequence when L1 is run with a regular reload.

Hope it helps.

[kamal_sanguri]

Hi,

Thanks for replying however I am getting error failed to open document. But when I remove \r from parameter I can open the file however it is just opening and reloading it.

Please advice

[kamal_sanguri]

Hi,

Thanks for reply, could you please elaborate. I have added a button and on External Launch event I have supplied these values. But when I click on it I get error Failed to open and after removing \r, file is opening but not reloading.

Please advise.

[maxgro · Accepted solution]

/r

not \r

[kamal_sanguri]

Thanks for catching this. It is working now but not perfectly.

I can reload the data for L1 by pressing button in L2 but the problem is when I increase the rows in excel file and press button in L2 it brings in all the data in L1 however when I remove few rows from excel file it still pulls the same number of rows.

[maxgro]

did you saved the excel?

blank rows? if yes try to add some where condition, example

where len(trim(somefieldinexcel))>0

[kamal_sanguri]

Yes, this is not about blank rows, I add new data in excel and press button in L2 and L1 is loaded with new data however when I do same thing after removing few rows L1 does not updated with new data and still shows old data.

[maxgro]

no idea at the moment but if you can post your L1 L2 and excel perhaps someone in the community can helps you