Even if already published on another Qlikview related blog I just wanted to have this here because I am using it quite often.
For starting/stopping/restarting the QlikView Windows-services of QlikView server in version 9 I have prepared three batch-scripts which I call on demand:
Restarting all QlikView related Windows-services
@echo off REM ------------------------------------------------------- REM - File: QlikViewServer9_Restart.bat REM - Description: Restart's QlikView Services (v9) REM - Author: Stefan WALTHER REM ------------------------------------------------------- echo Restarting QlikView Services echo ====================================================== net stop "QlikView WebServer" net stop "QlikViewServer" net stop "QlikView Publisher Command Center Service" net stop "Qlikview Management Service" net stop "QlikView Distribution Service" net stop "QlikView Directory Service Connector" net start "QlikView WebServer" net start "QlikViewServer" net start "QlikView Publisher Command Center Service" net start "Qlikview Management Service" net start "QlikView Distribution Service" net start "QlikView Directory Service Connector" echo ====================================================== echo QlikView restarted REM pause
(Just) stopping the QV Windows-services:
@echo off REM ------------------------------------------------------- REM - File: QlikViewServer9_Stop.bat REM - Description: Stop all QlikView related services (v9) REM - Author: Stefan WALTHER REM ------------------------------------------------------- echo Stop QlikView Services echo ====================================================== net stop "QlikView WebServer" net stop "QlikViewServer" net stop "QlikView Publisher Command Center Service" net stop "Qlikview Management Service" net stop "QlikView Distribution Service" net stop "QlikView Directory Service Connector" echo ====================================================== echo All QlikView related services have been stopped ... REM pause
(Just) starting the QV Windows-services:
@echo off REM ------------------------------------------------------- REM - File: QlikViewServer9_Start.bat REM - Description: Starts all QlikView related services (v9) REM - Author: Stefan WALTHER REM ------------------------------------------------------- echo Beginning to start QlikView Services echo ====================================================== net start "QlikView WebServer" net start "QlikViewServer" net start "QlikView Publisher Command Center Service" net start "Qlikview Management Service" net start "QlikView Distribution Service" net start "QlikView Directory Service Connector" echo ====================================================== echo All QlikView related services have been started ... REM pause
Related Downloads:
Possibly related posts:
- QlikTip #21: Running QlikView 8.5 and QlikView 9 side by side
Just a very short (very, very short) tip today. I was asked how one could run QlikView 8.5 and QlikView 9 one one system … That’s absolutely no problem. During the installation of QlikView 9... - QlikTip #17: Simulating the $(include) command in QlikView macros
Within load-scripts in QlikView there is the useful “$(include)” command available for including files containing some script to be used within the load-script. Doing so it is easy to encapsulate and reuse some code used...
Mag. Stefan WALTHER
12 Comments
Hello,
I wish to create a qlikview form customers by the way of a macro VBS.
When I clik on NEW button, I have a customer form appears.
Is it possible to create this form with these informations :
Fname : | Lname : | Country
City: | Company name : etc.
Thanks for your help.
Hi Judi,
what exactly do you want to achieve with this form? Inserting & Editing data?
Best regards
Stefan
Hi Stefan,
I want to create three buttons : NEW | UPDATE | DELETE
When I click on NEW button, I can edit customers informations (fname, lname, city,) by a validation form.
When I click on UPDATE button, I can update informations.
When I click on DELETE button, I delete entries.
Then, The NEW button add new entries in my SQL database and view last customer informations in the list
Then UPDATE button updates data on my table SQL SERVER.
Then DELETE button deletes entries
Afterwards I think there is all the condition doublon, etc.
Is it possible ?
Best regards.
Judi.
Hi Judi,
note that QlikView is primarily a *read only* analysis software.
There are is no builtin function for creating forms altough this can be done with the new feature “Real time update” introduced in QlikView 9. (Have a look at the chapter “Real-time data update” in the reference manual or “7. Using Automation for Dynami c Data Update” in the QlikView Automation Reference).
But note that there is not builtin functionality for creating forms, valdiating forms, so this would require quite a lot of custom code to achieve the required results.
There are some examples available at http://www.qlikview.com/community in the “Share QlikViews” section; just search for “update” there).
Hope this helps a little bit as a starting point …
Best regards
Stefan
Thank for helping.
Best regards,
Judi.
You’re welcome!
Best regards
Stefan
Last questions…
Where can I found the qlikview demo about Logistics & Transport.
I’ll wish to have examples or models already realized.
Thanks.
Best regards,
Judi
Regarding your questions:
- you can find several demos at http://demo.qlikview.com (but unfortunately there’s no demo available only targetign logistics & transport)
- I do have some solutions; but they are not ready for publishing here (give me some time and I will publish them here).
Best regards
Stefan
Thanks a lot for your patient.
Best regards,
Judi.
Hello,
I have a question, What is the best language to implement into QV so as certain basic statement work.
When I declare a variable like ” Dim a as Integer ” the VBScript engine don’t recognize Integer.
And In a QV model I saw ” qvlib.msgbox(” XXXX “). What is qvlib ?
VBScript is the only language to create macro in QV.
Best regards,
Judi.
Hello Judi again,
first: please do me a favour and use the comment-functionality here only related to the topics of the articles; this is not a discussion forum (you can find one at http://www.qlikview.com/community); otherwise I will unfortunately have to delete your questions here. Certainly I will try to answer the mail you have sent me yesterday … but please not here for general questsions!!!
Regarding your questions:
* You can use the macro editor to create scripts
* Possible scripting languages are VBScript and Javascript
* “Dim a” would be possible but “Dim a as Integer” does not work because this is VB and not VBScript (in VBScript you do not have a type-declaration (read e.g. http://activexperts.com/axscript/vbscriptintroduction/)
* qvlib.msgbox(“xxx”) is not necessary if you use VBScript; in VBScript you can just use Msgbox(“xxx”); QVLib is a helper class if you use Javascript because in Javascript you do not have a corresponding functionality for messageboxes like MsgBox in VBScript
Hope this helps a little bit.
Best regards
Stefan
I have 3 qvw files, each with 5 sheets of objects and data. I want to create a 4th qvw file that pulls sheet 5 from file 1, sheet 3 from file 2, sheet 4 from file 3. I want the sheets in the 4th file to be fully functional, complete with data. I don’t want to use “export sheet layout” and copy/paste the script into the 4th file. Can I use an include or if statement to pull in those 3 sheets of objects and data?
One Trackback
[...] QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 :Admin, QV9, Server [...]