Categories
Common Macros and Automatisation QlikView /en Tips n Tricks /en

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 […]

Categories
Macros and Automatisation QlikView /en Tips n Tricks /en

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 […]

Categories
Macros and Automatisation QlikView /en Tips n Tricks /en

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 […]

Categories
Macros and Automatisation QlikView /en QlikView Workarounds /en Tips n Tricks /en

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 […]

Categories
Common Macros and Automatisation QlikView /en QlikView Workarounds /en Tips n Tricks /en

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 Set obj = ActiveDocument.GetSheetObject(s.SheetObjects(i).getObjectId) Set objProp = obj.GetProperties Set […]

Categories
Macros and Automatisation QlikView /en Tips n Tricks /en

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. […]