Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

kamal_sanguri
Valued Contributor

Reloading different QVWs in continuation

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.

1 Solution

Accepted Solutions
MVP
MVP

Re: Reloading different QVWs in continuation

/r

not \r

11 Replies
MVP
MVP

Re: Reloading different QVWs in continuation

- 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

1.png

bruno_montenegr
Contributor III

Re: Reloading different QVWs in continuation

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
Valued Contributor

Re: Reloading different QVWs in continuation

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

$663A7C0B5DAA9B52.bmp

kamal_sanguri
Valued Contributor

Re: Reloading different QVWs in continuation

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.

$663A7C0B5DAA9B52.bmp

MVP
MVP

Re: Reloading different QVWs in continuation

/r

not \r

kamal_sanguri
Valued Contributor

Re: Reloading different QVWs in continuation

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.

MVP
MVP

Re: Reloading different QVWs in continuation

did you saved the excel?

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

where len(trim(somefieldinexcel))>0

kamal_sanguri
Valued Contributor

Re: Reloading different QVWs in continuation

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.

MVP
MVP

Re: Reloading different QVWs in continuation

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