Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kamal_sanguri
Specialist
Specialist

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
11 Replies
maxgro
MVP
MVP

- 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

Anonymous
Not applicable

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
Specialist
Specialist
Author

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
Specialist
Specialist
Author

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

maxgro
MVP
MVP

/r

not \r

kamal_sanguri
Specialist
Specialist
Author

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
MVP
MVP

did you saved the excel?

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

where len(trim(somefieldinexcel))>0

kamal_sanguri
Specialist
Specialist
Author

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
MVP
MVP

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