Kategorien
Allgemeines Makros and Automatisation Qlik Tips n Tricks

QlikView Dynamic TableBox Creation

Reason Sometimes it makes sense to pass some SQL Views through the whole ETL-Process to e.g. use the View “AS-IS” within a NPrinting Report. To achieve this behaviour, wenn need 2 dynamic steps:

Kategorien
Allgemeines Makros and Automatisation Qlik Tips n Tricks

Export a Chart or Tablebox via VBScript

As sometimes it makes sense to export data with a loop using VBScript. This little toolset should do the job for you: Sub ExecByFieldValues SET Doc = ActiveDocument SET Field = Doc.Fields(getVariable(“pstrFieldName”)) SET Values = Field.GetPossibleValues FOR i = 0 TO Values.Count-1 ExportObject Values.item(i).Text NEXT End Sub Be aware that you need some helpers: rem […]

Kategorien
Makros and Automatisation Qlik Tips n Tricks

Source Control for QlikView with git

What you need? So, facing the general question of “reasons” for lacking data quality, one of the most important thinks is transparency within the creation of the KPI’s. To reach this aim, I’ll switched to a full version control management with git to show my QlikView “customers” from where possible “issues” may resulting. To reach […]

Kategorien
Makros and Automatisation Qlik Tips n Tricks

QlikView User Access and Object Access

Introduction Security is one of the main topics and issues, deploying data to different users or group of users. Additional you have to seperate between data filters and object/feature visibilities. To achieve a individual “restriction” we split access rules into: ObjectRights (What a user can “see”) AccessRights (Which data a user can “browse”)  Scripts Here […]

Kategorien
Makros and Automatisation Qlik QlikView Workarounds Tips n Tricks

QlikView Export ChartTo XLS

This script enables you to export a ChartObject to xls by looping over a field, defined within a variable:  //Variables for the ExportObjectMakro Let pstrFieldName = “Standortname”; Let pstrExpObject = “CH526”; Let pstrExpPath   = “C:\ttemp”; REM ** MAKRO TO EXPORT OBJECT TO EXCEL ** rem Developed by Frenzel GmbH rem Author Philipp Frenzel Sub ExecByFieldValues […]

Kategorien
Allgemeines Makros and Automatisation Qlik QlikView Workarounds Tips n Tricks

Read and Write QlikView ObjectIDs by Macro

Here is a short script on how to read and write Object Id’s: SUB ReadObjectsAndSetId(SheetName)     rem ** minimize all sheet objects on sheet Main **     rem Author Philipp Frenzel     set s=ActiveDocument.Sheets(SheetName)     for i=0 to s.NoOfSheetObjects-1         ‘the formula for our rights management         varVisibility = s.GetProperties.SheetId & s.SheetObjects(i).getObjectId    […]

Kategorien
Makros and Automatisation Qlik Tips n Tricks

QlikView Makro PDF Print with BullZip PDFCreator QlikViewPDF

Getting the Printer First of all you need to download and install the printer from the official BullZip Webpage, which can be found here: http://www.bullzip.com After the download and installation (GhostScript Requiered) you’ll find a new Printer in your System Settings. QlikView Parts Preparing your System Go to the macro modul in your QlikView Client. […]