topic Re: Reloading different QVWs in continuation in QlikView

Reloading different QVWs in continuation

kamal_sanguri — Tue, 17 Jun 2014 17:02:34 GMT

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.

Re: Reloading different QVWs in continuation

maxgro — Tue, 17 Jun 2014 18:10:59 GMT

- 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

Re: Reloading different QVWs in continuation

Anonymous — Tue, 17 Jun 2014 18:19:10 GMT

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.

Re: Reloading different QVWs in continuation

kamal_sanguri — Tue, 17 Jun 2014 19:16:47 GMT

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

Re: Reloading different QVWs in continuation

kamal_sanguri — Tue, 17 Jun 2014 19:25:23 GMT

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.

Re: Reloading different QVWs in continuation

maxgro — Tue, 17 Jun 2014 19:35:58 GMT

not \r

Re: Reloading different QVWs in continuation

kamal_sanguri — Tue, 17 Jun 2014 20:18:48 GMT

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.

Re: Reloading different QVWs in continuation

maxgro — Tue, 17 Jun 2014 20:23:42 GMT

did you saved the excel?

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

where len(trim(somefieldinexcel))>0

Re: Reloading different QVWs in continuation

kamal_sanguri — Tue, 17 Jun 2014 20:32:39 GMT

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.

Re: Reloading different QVWs in continuation

maxgro — Tue, 17 Jun 2014 20:35:53 GMT

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

Re: Reloading different QVWs in continuation

kamal_sanguri — Tue, 17 Jun 2014 20:36:42 GMT

can u please check the attached files

Re: Reloading different QVWs in continuation

kamal_sanguri — Tue, 17 Jun 2014 20:42:51 GMT

Wow I guess it is working fine

Thanks for help