Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
QlikView documentation and resources.
This page will collect all relevant release information about Power Tools for QlikView, and will be continuously updated with each new release and with any patches that are issued. This way we hope for a more consolidated view of the Power Tools suite.
Power Tools 1.3.2 for QlikView
Power Tools 1.3.2 for QlikView - Release Notes
Power Tools 1.3.2 for QlikView - Readme
QlikView 12 compatibility matrix
12.0 | 12.1 | 12.2 | |
QlikView Server Agent | Yes | Yes | Yes |
QlikView Server Super Agent | Yes | Yes | Yes |
QMSClient | Yes | Yes | Yes |
Qv User Manager 10 | Not yet | Not yet | Not yet |
Qv User Manager 11 | Not yet | Not yet | Not yet |
QvsDetector | Yes | Yes | Yes |
QvServerObjectConnector | Not yet | Not yet | Not yet |
ReloadScheduleMigration | No | No | No |
ServerObjectHandler | Yes | Yes | Yes |
ServerObjectHandlerBatch | Yes | Yes | Yes |
SharedFileRepair | Not yet | Not yet | Not yet |
SharedFileViewer | Not yet | Not yet | Not yet |
XMLDBViewer | Yes | Yes | Yes |
Please note that this matrix only describes the compatibility with QlikView 12. It does not indicate whether or not Power Tools are officially supported, because they are not.
SharedFileViewer
Provides insight into the QlikView Server .shared files belonging to .qvw documents. The .shared file stores server data such as server/shared bookmarks, server objects (charts and objects created by a client via the server), annotations and other data that is specific to the document. The tool visualizes the content of the binary .shared file and provides options to "Repair" legacy files, as well as defrag large .shared files.
QvServerObjectConnector
A custom data connector for QlikView that much like the SharedFileViewer provides insight into .shared files, but instead allows to load data straight from .shared files into QlikView documents for analysis. The tool supports extraction of data like ownership, size and type of objects, expressions, annotations, bookmark selections (fields and values) and much more.
QlikView Server Agent
A small service utility that allows easy management of QlikView services. Also allows for quick change of credentials across multiple services at the same time.
QlikView Server Super Agent
A monitoring tool for QlikView Server, that monitors Qv services regardless of version (9+) and reports any service outage with email notifications and/or log files.
QMS API Client
A highly useful tool that gives its user the possibility to interact with the complete setup of QMS API functions in QlikView Server without typing a line of code. Visualizes data structures and enables the user to parameterize and test every function call based on their own data or data from the QMS API.
Qv User Manager
A command-line tool to list, add, remove and edit CAL and user information in a QlikView Server remotely.
QvsDetector
Scans the current subnet for other QlikView Servers and visualizes information like license, root folder, version and such. Also enables certain administrative functions.
Reload Schedule Migration Tool
A small step-by-step instruction tool that helps migrate reload schedules from non-Publisher databases in 9 to Publisher databases in 10 or 11, by manipulating the QVPR database (XML repository required) directly.
Server Object Handler
Enables listing, ownership changing and deletion of server objects in documents hosted on a QlikView Server remotely. Also allows ownership changing to be performed on a selected number of server objects matching a given name pattern.
Server Object Handler Batch
The command-line little brother of the Server Object Handler, that does all the same, but from any command prompt or batch script.
XmlDbViewer
Visualizes and enables searching in and editing of the QlikView Publisher Repository database (QVPR), when in XML format.
Shared File Repair
Uses the upgraded .shared file verify and repair functionality that was re-introduced in QlikView Server (QVS.exe) SR5, by providing a GUI to execute verify/repair operations on one or more .shared files and report the result. Note that even though the verify/repair functionality first came into QVS in 11.20 SR4, this version requires the upgraded functionality in 11.20 SR5.
Q: What is a Power Tool?
A: A Power Tool is a small utility program or application that aid in performing a specific functionality or that extends QlikView functionality in some other way.
Q: When should I use a Power Tool?
A: Power Tools should be used when there is a need for functionality that is not in the QlikView product suite already, to evaluate new functionality or when administrative actions outside that is not available as part of the regular program suite might be needed.
Q: Do I need to install any of the tools?
A: No, all tools are, as of this moment, drop-to-deploy tools. Be aware that some of them require resource files outside of the executable itself, like for example configuration files or DLL files. When deploying, make sure to deploy the whole folder and its content.
Q: Do the tools require administrative privileges?
A: Some of them require this, yes. It is up to each tool and its functionality. If you are using UAC (User Account Control) security, make sure to run the tools in privileged mode (right-click and select “Run as Administrator”).
Q: Is there any documentation for the Power Tools?
A: Yes. A limited documentation for the Power Tools is included in each of the separate tools.
Q: Are the Power Tools Supported?
A: No. The Power Tools are not supported and is seen as use-as-is tools, supplied separate from the QlikView product suite. *** Qlik is not responsible for any consequences such as environmental issues, data corruption, configuration errors or unexpected behavior, resulting from the use of Power Tools. ***
Q: Where do I report bugs in the Power Tools?
A: To report a bug, please visit our QlikCommunity Discussion Forums, for example the QlikView Management or QlikView Deploymentforums or send an email to SupportServiceabilityLabs@qlik.com. Bugs will be fixed between releases of the Power Tools entirely at Qlik's discretion.
Power Tools 1.3.1
Power Tools 1.3.1 for QlikView
Power Tools 1.3.1 for QlikView - Release Notes
Power Tools 1.3.1 for QlikView - Readme
Power Tools 1.3.0
Power Tools 1.3.0 for QlikView
Power Tools 1.3.0 for QlikView - Release Notes
Power Tools 1.3.0 for QlikView - Readme
Power Tools 1.2
Power Tools 1.2 for QlikView - Release Notes
Power Tools 1.2 for QlikView - Readme
Power Tools 1.1
Power Tools 1.1 for QlikView - Release Notes
Power Tools 1.1 for QlikView - Readme
Power Tools 1.0
Me and a colleague have put together a new Calendar, combining a super fast method for generating the needed calendar, while also removing a lot configuration options in the previous methods.
So if you're using a Min/Max based approach like the one described here: Creating A Master Calendar
Then you're properly used to waiting for the Min/Max to find the largest values in your dataset. This can take minutes. What we have here takes less than a second. I've actually not been able to time this, because this calendar script takes less than a 1 seconds even on billions of rows on decent hardware. The only exception to this is if you use a date range starting before christ and spans a thousand years. If you have a date range, with a lot of holes in it (dates with no data), then you should use the last parameter:
Call Calendar('[Date (NK)]','MyCal','Pre.','','true');
The Attached qvw shows both methods (remember the qvs file).
I've not commented it, because most people will not grasp what is going on anyway, and don't need to
To try it out, include the following in your script, and add this to your code:
Call Calendar('DateField');
/* ************************************************************************************
itelligence Standard Qlik Calender Torben Seebach/Martin Didriksen Special Thanks to Rob Wunderlich and John Witherspoon
Configure Calender parameters
Syntax:
Calendar(DateField[,CalendarName][,Prefix[,Suffix[,FullCalendar]]])
Example:
Call Calendar('Date (NK)','MyCal','Pre.','','true'); // creates a the MyCal table and fields are prefixed with Pre. In the superfast variat
Call Calendar('Date (NK)'); //creates a table called calendar based of "Date (NK)" field
Mandatory:
@_DateField Contains the name of the field to connect the calendar to
Optional:
@_CalendarName Contains the name of the calendar we create
@_CalendarPrefix A Prefix for all fields
@_CalendarSuffix A Suffix for all fields
@_FullCalendar If this contains a value then it creates a calendar with all dates from Min(Date) to Max(Date), default is the slowest option
************************************************************************************ */
Sub Calendar (_DateField,_CalendarName,_CalendarPrefix,_CalendarSuffix,_FullCalendar)
Let _StartTime = Now();
Let _CalendarName = If(Len('$(_CalendarName)')=0,'Calendar','$(_CalendarName)');
Let _CalendarPrefix = If(Len('$(_CalendarPrefix)')=0,'','$(_CalendarPrefix)');
Let _CalendarSuffix = If(Len('$(_CalendarSuffix)')=0,'','$(_CalendarSuffix)');
Let _FullCalendar = If(Len('$(_FullCalendar)')=0,1,0);
Let _DateField = PurgeChar(_DateField,'"[]');
"$(_CalendarName)":
LOAD
Distinct [$(_DateField)] as [$(_DateField)],
Text(Date([$(_DateField)])) as [$(_CalendarPrefix)DateText$(_CalendarSuffix)],
Year([$(_DateField)]) as [$(_CalendarPrefix)Year$(_CalendarSuffix)],
Week([$(_DateField)])&'-'&Year([$(_DateField)]) as [$(_CalendarPrefix)WeekYear$(_CalendarSuffix)],
Week([$(_DateField)]) as [$(_CalendarPrefix)Week$(_CalendarSuffix)],
Month([$(_DateField)]) as [$(_CalendarPrefix)Month$(_CalendarSuffix)],
Year([$(_DateField)])&'-'&Text(Date([$(_DateField)],'MM')) as [$(_CalendarPrefix)YearMonth$(_CalendarSuffix)], 'Q'&Ceil(Month([$(_DateField)])/3) as [$(_CalendarPrefix)Quarter$(_CalendarSuffix)],
AutoNumber(MonthStart([$(_DateField)]),'_MonthSerial') as [$(_CalendarPrefix)MonthSerial$(_CalendarSuffix)],
AutoNumber(QuarterStart([$(_DateField)]),'_QuarterSerial') as [$(_CalendarPrefix)QuarterSerial$(_CalendarSuffix)],
AutoNumber(weekyear([$(_DateField)]) &'|'&week([$(_DateField)]),'_WeekSerial') as [$(_CalendarPrefix)WeekSerial$(_CalendarSuffix)] ;
If _FullCalendar=1 Then
LOAD Date(_DateStart+(Iterno()-1),'$(DateFormat)' ) as [$(_DateField)]
While (_DateStart+(Iterno()-1)<=_DateStop);
LOAD
Floor(Min(Fieldvalue('$(_DateField)',RecNo()))) as _DateStart,
Floor(Max(Fieldvalue('$(_DateField)',RecNo()))) as _DateStop
AUTOGENERATE FieldValueCount('$(_DateField)');
Else
LOAD Num(Fieldvalue('$(_DateField)',RecNo())) as [$(_DateField)]
AUTOGENERATE FieldValueCount('$(_DateField)');
End If
/* clean variables */
Let _TotalTime = Round((Now()-_StartTime)*60*60*24,0.00000000001);
Let _StartTime = NULL;
Let _vDateStart = NULL;
Let _vDateStop = NULL;
Trace $(_CalendarName) created in: $(_TotalTime) seconds;
Let _TotalTime = NULL;
ENDSUB
Updated 2014-05-23:
Other than my brilliant Collegue Martin Didriksen, I also want to give John Witherspoon some credit for inspiration on the autogerate method used. I think he was the first who posted it online.
A derivative of the QlikView System Monitor for versions 10/11, finally the QlikView 12-compatible version has arrived. The UI has undergone some changes and the structure/setup has been simplified. This application will read your QVS machine logs and output all kinds of information for you, such as virtual memory warnings, PGO/.Shared errors, user trending and utilization, and chronological logging events across the system.
If you're looking for the QV 11.2 version, please find it here.
Thanks for your patience and if you have any questions/comments please post to this thread!
Best,
MT !
Power Tools for QlikView
Version: 1.3.2
..again! A small update of one tool, and test of another.
https://www.dropbox.com/sh/8hac72aljgqlr7d/AAASkzbM2H1OoVcLE_wa0kWGa?dl=0
For the absolute latest version, please see Power Tools for QlikView - One-stop-shop
QlikView 12.X support matrix
12.0 | 12.1 | 12.2 | |
QlikView Server Agent | Yes | Yes | Yes |
QlikView Server Super Agent | Yes | Yes | Yes |
QMSClient | Yes | Yes | Yes |
Qv User Manager 10 | |||
Qv User Manager 11 | |||
QvsDetector | Yes | Yes | Yes |
QvServerObjectConnector | |||
ReloadScheduleMigration | No | No | No |
ServerObjectHandler | Yes | Yes | Yes |
ServerObjectHandlerBatch | Yes | Yes | Yes |
SharedFileRepair | |||
SharedFileViewer | |||
XMLDBViewer | Yes | Yes | Yes |
Reviewed/updated with support for QlikView 12
Release notes here: Power Tools 1.3.2 for QlikView - Release Notes
Readme here: Power Tools 1.3.2 for QlikView - Readme
Want to collaborate?
Do you have questions, thoughts, suggestions or bugs to report on Power Tools? Please post in the forums on QlikCommunity: https://community.qlik.com/community/qlikview/management
Also check out our (currently dead, soon to be revived) Twitter: @QvPowerTools
DISCLAIMER
Power Tools are a collection of software programs and tools used for troubleshooting purposes only. Power Tools are provided free of charge and are not supported. Power Tools are not official QlikView products and are provided without warranty. Use of Power Tools is entirely at the user's own risk.
Hi All,
This document helps you in loading multiple excels and excel sheets with the name of the sheet and data.
//to read each file from the specified folder
FOR EACH file in FileList('filepath\*.xlsx');
//In order to get the file information from SQLtables command making use of the ODBC connection format
ODBC CONNECT32 TO [Excel Files;DBQ=$(file)];
tables:
SQLtables;
DISCONNECT;
FOR i = 0 to NoOfRows('tables')-1
LET sheetName = purgeChar(purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39)), chr(36));
Table:
Load * ,
FileBaseName()as FIle,
FileDir() as Dir,
FileName() as File_Name,
'$(sheetName)' as Sheet_name
From $(file)(ooxml, embedded labels, table is [$(sheetName)]);
NEXT i
Next
Hope this helps !!!
please find the attachment for the eg: qvw and test fiels
Regards,
An explanation of the following type of QlikView Event Log Errors:
"Restart: Server aborted trying to recover by restart. Reason for restart: Internal inconsistency, type ?, detected."
Hello Everyone,
I have attached the document for the important Qlikview functions used in script as well as in UI.
Please have a look and also feel free to update the document or comment in the session for the functions which is missed.
Greetings to all.
I love Qlik, but lately I do not have enough time to keep track of everything that happens.
I have to visit many resources for reading news, articles, tricks, videos.
I set myself the goal of being aware of everything, and spend no more than 5 minutes a day on it.
What can help us with this, of course RSS!
For a long time I tried to find a decent and at the same time a simple program for reading rss's ... and found - QuiteRSS (https://quiterss.org/).
Then I started to compile a list of interesting sites for me and add them to QuiteRSS.
At the moment, there is no particular hierarchy of feed, but I think that it will be needed.
Yes, I am sure that there are other sources of information, but I have not found them.
I propose to work on this issue together and lead an acute list.
Git Repo : https://gitlab.com/bintocher/QlikRSS
Can't attach new file, so link : https://gitlab.com/bintocher/QlikRSS/raw/master/qlik%20docs.opml
Updated 2019.01.22 - now total 53 rss feeds ; updated qlik community rss links
Power Tools for QlikView
Version: 1.2
https://www.dropbox.com/sh/8hac72aljgqlr7d/AAASkzbM2H1OoVcLE_wa0kWGa?dl=0
For the absolute latest version, please see Power Tools for QlikView - One-stop-shop
In this release:
Release notes here: Power Tools 1.2 for QlikView - Release Notes
Readme here: Power Tools 1.2 for QlikView - Readme
Patches
Want to collaborate?
Do you have questions, thoughts or suggestions? Maybe you want to report a defect in the Power Tools? Please post it in the Management forum on QlikCommunity: http://community.qlik.com/community/discussion-forums/management
Also check out our Twitter: @QvPowerTools
DISCLAIMER
Power Tools are a collection of software programs and tools used for troubleshooting purposes only. Power Tools are provided free of charge and are not supported. Power Tools are not official QlikView products and are provided without warranty. Use of Power Tools is entirely at the user's own risk.
Power Tools for QlikView
Version: 1.3.0
Yes, it's actually true! Long story short; we'll be starting to release smaller releases, where we add support for QlikView 12.X continuously in the existing tools. Hence the 1.3.0 version. We'll continue with fixes and move on like 1.3.1, 1.3.2, and so on. Keep an eye out for the next release!
For the absolute latest version, please see Power Tools for QlikView - One-stop-shop
Updated with support for QlikView 12:
Legacy (not yet with QlikView 12 support):
Release notes here: Power Tools 1.3.0 for QlikView - Release Notes
Readme here: Power Tools 1.3.0 for QlikView - Readme
Want to collaborate?
Do you have questions, thoughts, suggestions or bugs to report on Power Tools? Please post in the forums on QlikCommunity: https://community.qlik.com/community/qlikview/management
Also check out our (currently dead, soon to be revived) Twitter: @QvPowerTools
DISCLAIMER
Power Tools are a collection of software programs and tools used for troubleshooting purposes only. Power Tools are provided free of charge and are not supported. Power Tools are not official QlikView products and are provided without warranty. Use of Power Tools is entirely at the user's own risk.
Power Tools for QlikView
Version: 1.3.1
Here we go again! We've tested some more tools, and updated some others with support for QlikView 12.X. Enjoy!
https://www.dropbox.com/sh/8hac72aljgqlr7d/AAASkzbM2H1OoVcLE_wa0kWGa?dl=0
For the absolute latest version, please see Power Tools for QlikView - One-stop-shop
QlikView 12.X support matrix
12.0 | 12.1 | 12.2 | |
QlikView Server Agent | |||
QlikView Server Super Agent | |||
QMSClient | Yes | Yes | Yes |
Qv User Manager 10 | |||
Qv User Manager 11 | |||
QvsDetector | Yes | Yes | Yes |
QvServerObjectConnector | |||
ReloadScheduleMigration | No | No | No |
ServerObjectHandler | Yes | Yes | Yes |
ServerObjectHandlerBatch | Yes | Yes | Yes |
SharedFileRepair | |||
SharedFileViewer | |||
XMLDBViewer | Yes | Yes | Yes |
Reviewed/updated with support for QlikView 12
Release notes here: Power Tools 1.3.1 for QlikView - Release Notes
Readme here: Power Tools 1.3.1 for QlikView - Readme
Want to collaborate?
Do you have questions, thoughts, suggestions or bugs to report on Power Tools? Please post in the forums on QlikCommunity: https://community.qlik.com/community/qlikview/management
Also check out our (currently dead, soon to be revived) Twitter: @QvPowerTools
DISCLAIMER
Power Tools are a collection of software programs and tools used for troubleshooting purposes only. Power Tools are provided free of charge and are not supported. Power Tools are not official QlikView products and are provided without warranty. Use of Power Tools is entirely at the user's own risk.
QlikView: A Wonderfull User Experience!!
The Mirable Miracle of Pixel Perfect Developer Work Space...
Some my personal "best practice" document to UI with mustache!:
A User Experience with Big <U > ! The DashBoard with mustache!
15K Mirable New Collection Icons with Mustache by Valerio Fatatis.rar
Qlik Library Objects by Valerio Fatatis with MUSTACHE! ver 3
10.000 WONDERFULL IOS Icons with Mustache by Valerio Fatatis
Pre Sales Demo App with Mustache by Valerio Fatatis.qvw
QlikView UI Best Practice by Valerio Fatatis Ridotta.pdf
QlikTemplate_Ver_1 by Valerio Fatatis ValueLab.qvw
A Rapid "Fast Calendar Selections...", a great boost of multi periods analysis! ...
Working & Project in Qlikview
How to make a fantastic graphics, amazing to win! with Mustache by Valerio Fatatis
10.000 WONDERFULL IOS Icons with Mustache by Valerio Fatatis
Optimize Configurator in the ALL Projects activity planning V2
Pre Sales Demo App with Mustache by Valerio Fatatis.qvw
Sales Analize with MUSTACHE! by Valerio Fatatis.qvw
Performance Advanced Analysis with Mustache by Valerio Fatatis.qvw
QlikView Advanced UI Design and more...
David and Goliath by Valerio Fatatis.qvw
Hi, I just want to use the opportunity to share some tips on my experience with working on T24 database source which was really challenging for me. The Qlik community has been a lot of help for me on Qlik projects and have had to rely on the many professionals and users documents and tips to aid myself. And this has led me to put up this little piece hoping I could also contribute my little to this wonderful community.
Regards,
Ayodele