Auf Anfrage habe ich das Sense Server CookBook doch noch mal vorgezogen. Single Node Multi Node DMZ
Der Beitrag Deployment CookBook wächst weiter… erschien zuerst auf qlik.binom.net.
Da es ja leider viele Seiten aus der Hilfe nicht in Deutsch gibt. Werde ich diese hier nun bereitstellen: Qlik Sense Server Ports
Der Beitrag Deployment CookBook für Sense wächst erschien zuerst auf qlik.binom.net.
Damit sind nun auch die wichtigsten Funktionen online, welche oft für zusammengesetzte Schlüssel benötigt werden. NetworkDays() trim(), lTrim() und rTrim()
Der Beitrag weitere Funktionen … erschien zuerst auf qlik.binom.net.
Dazu habe ich im Development CookBook auch noch ein neues Kapitel eröffnet um damit noch zu verdeutlichen wo ich die Funktionen im wesentlichen nutze. Denken Sie daran das viele Dinge besser im Skript als an der Oberfläche erledigt werden sollten. Development Cookbook: floor() und ceil() Upper() und Lower() left(), right() und mid() PurgeChar(), KeepChar() und […]
Die ersten vier Einheiten sind bereits fertig die nächsten 4 sind in Arbeit und werden wahrscheinlich bis Sonntag auch folgen. Diagramm Funktionen sum(), count() und DISTINCT Rechnen mit column() und Bezeichnung min(), max() und avg() TOTAL und ALL
Der Beitrag Neuer Bereich im Design CookBook erschien zuerst auf qlik.binom.net.
Sollte es nach dem Upgrade oder dem migrieren einer App innerhalb von Set Analysis zu Problemen kommen, liegt das sicherlich an dem internen Handling von einfachen und doppelten Anführungszeichen. in der Settings ini kann man unter Settings7 folgenden Eintrag mit dem enttäuschendem Wert einfügen: 0 = alle apps haben das alte Verhalten1 = neue Apps […]
Der Beitrag Anführungszeichen in Set Analysis erschien zuerst auf qlik.binom.net.
Werden Sie Teil der Datenrevolution Machen Sie den ersten Schritt und registrieren Sie sich noch heute Das digitale Zeitalter ist angebrochen. Es ist Zeit, Ihre Daten zu befreien. Nehmen Sie im Dezember am Data Revolution Virtual Forum teil und erfahren Sie mehr.Von inspirierenden Referenten wie Donald Farmer (TreeHive) und Martha Bennett (Forrester) bis hin zu einer faszinierenden […]
Mit dem nächsten Service Release wird es ein offizielles Extension Bundle seitens Qlik geben. Die in dem Bundle enthaltenen Extensions werden dann auch von Qlik supported. Das Packet wird auch eine Extension zum ändern von Variablen durch den Benutzer enthalten.
Der Beitrag Erstes offizielle Extension Bundle wohl mit dem nächsten Release verfügbar. erschien zuerst auf qlik.binom.net.
mit der Extension WRITE! können Sie Daten in QlikView oder Qlik Sense direkt im Report bearbeiten und diese in der Datenbank speichern. Damit bieten sich neue Möglichkeiten wie Planung, Korrektur und mehr. Die Extension können Sie hier kostenpflichtig beziehen: https://www.inform-software.de/produkte/business-intelligence/write
QlikView 4 QlikSense Mashup Beta jetzt online. Hier geht’s zum download: https://github.com/Ac1d0n3/myMashup Es sind noch ein paar kleine Käfer in dem Mashup und die BETA läuft nur mit Qlik Sense > September 2018. Für Versionen davor muss in den URLs wieder das ! hinter der # entfernt werden. Dafür wird es im nächsten Update eine Variable […]
Mit dieser Extension können Sie bequem Kommentare zu Ihren Daten nutzen und dieser in einer Datenbank speichern. Qomment™ – Qlik Native Write Back Extension
Der Beitrag Sense – Daten kommentieren erschien zuerst auf qlik.binom.net.
Qlik Data Catalyst™, formerly Podium Data, can enable your end-to-end enterprise data management strategy, helping transform your raw data into a governed, analytics-ready information resource regardless of whether you use Qlik Sense®, QlikView® or other analytics solutions. Ein weiterer Meilenstein für Qlik https://www.qlik.com/us/products/qlik-data-catalyst
One of my goals in doing presentations and classes on Qlik Sense APIs is to get people to see the “Art of the Possible” — that is, seeing what opportunities may exist in your organization to leverage the power of the associative engine and the Sense APIs, beyond the standard client and hub.
Today I’ll highlight a demo built by my colleague Nick Webster. This chart actually came out of a class when a student asked “could we…”.
hier schon mal ein appetizer auf das Mashup was ich bald als erstes Template Online stelle: Das Dashboard ist komplett generisch – alle Diagramme werden über die Viz API erstellt. Kein Set Analysis notwendig – nur Angabe der Felder aus dem Kalender. Filtergruppen – die pro View eingeblendet werden können. Variablen Eingabe ohne Extension per […]
Der Beitrag QlikView 4 Qlik Sense bald online erschien zuerst auf qlik.binom.net.
Wer auch den Code Editor von Sense farblich anpassen möchte findet hier eine entsprechende Anleitung: Theming the Qlik Sense Script Editor
Der Beitrag Den Sense Scripteditor vom Design anpassen erschien zuerst auf qlik.binom.net.
Einige Diagrammtypen fehlen noch in der Liste die wichtigsten sind aber soweit erst mal online. QlikView Diagramme
Der Beitrag QlikView Diagramme im Design CookBook erst mal fertig erschien zuerst auf qlik.binom.net.
Damit ist das Kapitel Variablen für QlikView soweit komplett. QV – Variablen
Der Beitrag Weitere 4 Einheiten im Design CookBook für QlikView fertig erschien zuerst auf qlik.binom.net.
QV – Listbox / Multibox (Filter) QV – Status und Suchbox
Der Beitrag Nächsten 2 Einheiten im Design CookBook QlikView fertig erschien zuerst auf qlik.binom.net.
QV – Grundeinstellungen QV – Einführung
Der Beitrag Ersten beiden Kapitel im Design CookBook für QlikView fertig erschien zuerst auf qlik.binom.net.
Hier eine kleine Qlik Sense App welche die Daten der Apple Watch auswertet. Um an die Daten zu kommen benötigt ihr die App QS-Access aus dem Apple App Store. Die App benutzt die Extension bnQSInput für ein Arbeitsblatt. http://qlik.binom.net/AppleHealthqvf.zip
Der Beitrag Apple Health Daten in Qlik Sense V1 erschien zuerst auf qlik.binom.net.
Es wird sicherlich noch kleine Updates geben, der Bereich zum Framework ist soweit aber erst mal fertig. Qlik Developer Framework Als nächstes wird das CookBook fertig gestellt und dann folgen die nächsten Tutorials zum Thema Mashups und Extensions.
Der Beitrag Bereich Developer Framework soweit fertig erschien zuerst auf qlik.binom.net.
Egal ob Mashup, Extensions oder die eigene Webseite,… Entweder Sie nutzen Bootstrap, ein Framework für Responsive Design oder: Nutzen Sie CSS Grid für Ihr Layout und für Ihre Schrifgröße anstelle von pixel em oder Prozent die vmax dieses Attribut bezieht sich auf die größere Angabe von vMin und vMax. Diese beiden Attribute beziehen sich wiederum auf […]
Gehen Sie in den Berabeitungsmodushängen Sie /options/developer ans Ende der URL und drücken Sie Enter damit die Seite neu lädt.Klicken Sie mit der rechten Maustaste auf ein Chart und dann auf Developer um Informationen wie die Chart ID zu erhalten.
Der Beitrag /options/developer erschien zuerst auf qlik.binom.net.
Ab heute ist auch die QlikView Variante von dem Framework auf GIT verfügbar. Die Anleitung ist noch nicht ganz fertig, wird aber die Tage folgen. 4 QlikView
Der Beitrag Developer Framework 4 QlikView jetzt auf GIT erschien zuerst auf qlik.binom.net.
Für einen besseren Start mit dem Framework.
Der Beitrag Qlik Sense Framework jetzt mit Workflow für Stage 1-3 erschien zuerst auf qlik.binom.net.
Der Bereich QS Charts enthält jetzt auch eine Beispieldatei welche den Einsatz der MasterItems zeigt. Die Masteritems wurden mit den Variablen aus dem Skript BI-Governance-Master.qvs verknüpft. Die entsprechenden Übersetzungen kommen auch aus dem Framework (GUI-Languages.qvs). QS Charts
Der Beitrag Jetzt mit Beispieldatei zum mitmachen erschien zuerst auf qlik.binom.net.
Neu im Theme: Menü Leiste eingefärbtIcon Farben geändert@ qlik.binom.net an den App Titel gehängtInsight Buttonfarbe und BildHintergrundfarbe des Alle Filter FensetersHintergrundfarbe der App Informationen
Der Beitrag BinomTheme V3 erschien zuerst auf qlik.binom.net.
Damit der Einstieg ein wenig einfacher fällt habe ich das Mashup Tutorial noch mal ein wenig ergänzt. Entsprechende Videos mit den Einzelnen Schritten wird es sicherlich auch bald geben.
Der Beitrag Mashup Tutorial nach letztem Qlik Event erweitert erschien zuerst auf qlik.binom.net.
Ich habe an dem Theme noch 4 Anpassungen vorgenommen: SelektionfarbenSchriftartTitel jetzt immer in Großbuchstaben# vor dem Titel Zudem wurde ein fix für das September Release eingebaut.
Der Beitrag binomTheme Version 2 erschien zuerst auf qlik.binom.net.
Mit der True Chart Menu Bar haben Sie eine Extension die viele Möglichkeiten für Variablen, Slider, Filter etc. bietet. Hier geht’s zur trueChart MenuBar Die trueChart Menu Bar stammt von einem langjährigen Partner von Qlik und bietet eine gute Ergänzung im Bezug auf dynamische Dashboards.
Der Beitrag trueChart MenuBar erschien zuerst auf qlik.binom.net.
Ich möchte heute noch mal die Extension Vizlib vorstellen, diese erweitert Qlik Sense um einige nette Visualisierungen. Vizlib gehört zu den Certified Exentsions von Qlik Sense, womit Sie für diese entsprechenden Support erhalten können (je nach Lizenzmodell ggf. weitere Kosten). Mehr erfahren Sie auf https://www.vizlib.com/ Vizlib bietet eine Vielzahl an schicken Charts an, ein neues […]
Sie wollen Ihre Farbgebung in Qlik Sense an Ihre Coperate Farben anpassen? Auf https://sensetheme.com/ können Sie genau dies tun und sich anschließend das erstelle Theme herunterladen um es in Ihrer Umgebung zu nutzen.
Der Beitrag Sense Theme Maker erschien zuerst auf qlik.binom.net.
Hier nochmal ein Überblick alle Lektionen: Inhalt: Basefiles (benötige Dateien für Ihr Projekt)Objekte über den Dev-Hub hinzufügen (Klassen qvplaceholder und qvobject)Debuggen mit den Chrome EntwicklertoolsSkripten im alternativen Editor (Atom)Zugriff auf Frameworks welche in Sense vorhanden sindCharts mit jQuery Ein- und Ausblenden und Qlik.Resize() jQuery-UI Komponenten einbindenjQuery-UI Komponenten nutzen – TabsQlik Navigation erstellen – Auswahl (zurück / […]
Die neue Startseite zu meinem Lieblingsthema Mashups ist jetzt fertig. Sie bietet Ihnen einen schnelle Zugriff auf das Tutorial, die wichtigsten Ressourcen welche Sie für die Mashup Entwicklung benötigen. Der Bereich wird natürlich weiterhin ausgebaut. Sense – Mashups
Der Beitrag Startseite Mashups fertig erschien zuerst auf qlik.binom.net.
Die nächsten drei Kapitel vom Mashup Tutorial Einsteiger sind fertig: jQuery-UI Komponenten einbindenjQuery-UI Komponenten nutzen – TabsQlik Navigation erstellen – Auswahl (zurück / löschen / vorwärts)Berechnungen seitens des Mashups durchführen Die letzen beiden Einheiten werden in kürze folgen.
Der Beitrag Nächsten 4 Kapitel im Mashup Tutorial Einsteiger fertig erschien zuerst auf qlik.binom.net.
Die ersten Videos sind nun in den Einheiten enthalten, der Rest folgt in Kürze. Folgende Charts sind so weit: QS FilterQS Text und BildQS BalkendiagrammQS LiniendiagrammQS KuchendiagrammQS KombidiagrammQS TabelleQS PivotQS PunktdiagrammQS Baumkarte QS Charts
Der Beitrag Jetzt auch mit Video der jeweiligen Schritte erschien zuerst auf qlik.binom.net.
Atom basiert wie Qlik Sense auf NodeJS und ist für Win und Mac oder Linux verfügbar. Warum ich ATOM so liebe? Atom ist kostenlos Ideal für WebentwicklerGIThub ist schon an BordTypeScript gibt es als PackageUnterstützt die Qlik Languageweitere nette Packages sind verfügbar um Prozesse zu vereinfachen
Der Beitrag Atom.io mein neuer Editor erschien zuerst auf qlik.binom.net.
Oft kommt im Training die Frage auf wie man Qlik Scripte am besten Versioniert und Dokumentiert. Der Einfachste Weg ist meiner Meinung nach das auslagern der Scripte in eigene Textdateien. Diesen gebe ich anstelle der Endung “.txt” die Endung “.qvs”. So kann man diese mit *.qvs im Dateisystem besser finden. Warum Textdateien? Ganz einfach diese […]
Mit Hilfe der App Integration API können Sie innerhalb Ihrer Sense App auf eine andere App zugreifen um deren Werte zur erhalten. Sie können beim Aufruf eine Selektion mitgeben Sie Beispiel:
Der Beitrag In einer Sense Formel auf eine andere App zugreifen erschien zuerst auf qlik.binom.net.
Qlik Recognized as Partner Driving New Joint Opportunities Built on Cloudera’s Platform October 02, 2018 Radnor, PA – Oct. 2, 2018 – Qlik®, a leader in data analytics, was recently recognized as a multiple Partner Impact Award winner at Cloudera’s annual Partner Summits held in New York and Amsterdam. “We’re honored to receive these awards from […]
Leonardo UI Sie benötigen Icons aus Sense wie z.B das Icon. Sie wollen in Ihrem Mashup oder Extension die selben GUI Komponenten wie Sense selber nutzen? Mit diesem Framework erreichen Sie genau dies.
Der Beitrag Leonardo UI – Qlik Icons und mehr erschien zuerst auf qlik.binom.net.
Die Seite branch.qlik.com wurde vor einigen Tagen umgebaut, wenn Sie die Extensions suchen die kosten- und supportfrei erhältlich sind finden Sie diese nun in dem Bereich Garden:
Der Beitrag Wo finde ich auf Branch die Extensions? erschien zuerst auf qlik.binom.net.
Hier die ersten fertigen Einheiten, weitere folgen … Einstieg Skripten Debuggen Einstieg ins Daten laden
Der Beitrag Erste Einheiten vom Development CookBook fertig erschien zuerst auf qlik.binom.net.
Lately I’ve been digging into an old Qlik performance question. How much impact, if any, does the order of Qlik data tables have on chart calc time? My experience is that for a chart or aggr() cube with a lot of dimension values, ordering of rows by dimension values can have a significant and measurable effect.
Summary: In this post I show how to modify the style of the QS Script Editor window.
An astute reader — Johan Roelofsen — of my blog on bookmarklets noticed I had a bookmarklet named “QS Blackboard” and asked if this was used to change the window background color. Excellent guess, spot on, but there’s more to it.
The 15th edition of the Masters Summit for Qlik will take place October 3-5 2018 at the Bellevue Hotel in Philadelphia PA . Our goal in this three day hands on education event is to “Take your Qlik skills to the next level” to make you more productive and increase the business value of your QlikView or Qlik Sense applications.
I just read a good post by Kamal Kumar Sanguri on QlikCommunity. Kamal’s post reminded me that managing variables in QlikView has always presented some challenges and over the years various techniques and code snippets have been shared to address those challenges.
Most folks quickly find that maintaining variables in external files loaded with a script loop is a good approach and resolves common concerns regarding shareability, dollar sign escaping and so on.
Summary: In this post I present a non-intrusive bookmarklet to hide the Sections pane in the Qlik Sense Script Editor to provide more real estate for typing script.
I sometimes wish for a larger window in the Qlik Sense Script Editor where we type statements. This is especially true when I am projecting and I’ve zoomed my browser to make the text legible to the audience, or I’m saddled with a very low resolution.
I just wrapped up the week at Qonnections 2018. I found it to be an inspiring conference and the most positive I’ve attended in years.
What was inspiring? The cognitive insights demo was fantastic. This is the future of BI. We have well understood principles and algorithms recently formalized in the discipline of machine learning. Let’s incorporate them in the tool. If the goal of data visualization is to amplify cognition of data, then I would say cognitive insights is to visualization as visualization is to data.
In the Qlik world, we are frequently faced with questions like:Where did this field come from? What applications (if any) use this QVD? If I change this database table, what applications will be affected? Am I creating QVDs that are not being consumed?
I’ve maintained a QlikView lineage application for my customers over the years. I was never completely happy with it as Qlik lineage metadata is inconsistent and the critically important field level lineage was never available.
Summary: AutoNumberHash128(A, B) runs about 30% faster than AutoNumber(A &’-‘ & B).
It’s a common practice to use the script AutoNumber() function to reduce the storage required for large compound keys in a Qlik data model. For example:AutoNumber(A & '-' & B) as %KeyField
As a standard practice, we generally include a separator like ‘-‘ to ensure ‘1’ & ’11’ does not get confused with ’11’ & ‘1’.
The AutoNumber process can add significant run time to a script with many rows.
Are you going to Qonnections in Orlando April 23? I’ll be there and presenting three breakout sessions. In addition to checking in with colleagues and hearing about what’s new, here are some things I’m looking forward to:Hearing from the new Leadership team Qlik Core! Learning more about subscription pricing Freakonomics!
I’ll be presenting three technical breakout sessions.
Qlik Sense added a Distribution Plot visualization in the June 2017 release. QlikView does not have a specific chart type for distribution plot, but you can achieve the same with a scatter plot.
The trick is to set the Y value (Expression #2) to a constant value such as “1”. Here’s a distribution of Life Expectancy by Country (source: WHO 2017).
Qlik has been named a Leader in the 2018 Magic Quadrant for Business Intelligence and Analytics Platforms for the 8th consecutive year. Although Tableau and Microsoft seem to have expanded their lead, Qlik has made some excellent progress along the “Completeness of vision” axis. With all the cool stuff that is coming up in the next year, I am sure this will be followed next year by more success along the “Ability to execute” axis.
Lots of great presentations at the QDG Guru day in London last week. Every talk gave me something to think about or explore futher.
Bruno Calver’s discussion of cohort/analysis (from his excellent white paper “Data Literacy –5 Practical Tips“) and Patrik Lundblad’s discussion of multivariate analysis blended together (mashed up?) in my mind to inspire the example below.
The 14th edition of the Masters Summit for Qlik will take place in Prague on 3-5 April 2018. In this three day hands on education event our goal is to “Take your Qlik skills to the next level” making you more productive and increasing the business value of your QlikView or Qlik Sense applications.
The Masters Summit for Qlik is coming to Prague from April 3 to 5. If you’ve read this blog before, you probably have a good idea of what it is about: we’re going to take your Qlik skills to the next level!
For those of you that want to join us, but need to nudge the internal approval process a little bit, I have prepared a short presentation. This presentation lays out the event, content, speakers and, most importantly, the value to you and your organization.
Summary: In Qlik script SET is often a better choice than LET, even when the value contains quotes.
I sometimes see the LET script statement used when SET would be syntactically easier and more readable.
A brief review: SET assigns the given parameter as-is to the variable, LET treats the parameter as an expression and assigns the evaluated result to the variable.SET x = 1+3; // x is "1+3" LET x = 1+3; // x is "4"
I frequently see a variable assignment like this:
I’m really appreciating the Qlik Sense Mashup facility. In the simplest case, mashups are when you embed Sense charts in a web page. Super easy with Sense.
Perhaps you’ve created some charts in your app that exist solely to serve the mashup. What if you want to display these charts in the mashup but you don’t want them showing in a sheet when the app is viewed via the hub?
I’m pleased to announce that I’ve acquired the excellent QViewer tool from Dmitry Gudkov effective January 1. I’ll be marketing, developing and supporting QViewer going forward.
QViewer has a stellar reputation as a must have tool for Qlik Developers. I’m pleased to be taking over such a fine product.
This acquisition is one step in my plan to focus more on software development during 2018. Stay tuned for other announcements during the year.
I’m pleased to announce that I’m joining forces with the team at websy.io! I look forward to bringing the websy training offerings to locations in the US as an Instructor and event organizer.
I’m also excited about the opportunities to bring websys’s recognized expertise to Qlik Sense Integration and Visualization projects throughout the world.
Summary: In this post I describe a process using freely available tools to apply changes to all scripts in a set of QVW files.
So you have a lot of QVWs. And now you are asked to identify and make updates to all scripts to support changes such as:
Summary: QV11 contained an inconsistency in how variables with equal signs were evaluated when using Alternate States. This has been fixed in QV12.10. Read on if you want the details.
QlikView V12.10 includes an important fix to variable evaluation when using alternate states. A quote from the Release Notes:
I’ve received several requests to provide a batch interface to the popular QV Document Analyzer tool that will provide for analyzing multiple QVWs with a single command. It’s now available for download here.
The script is a windows cmd file. Because many browsers block download of cmd files, I’ve provided it with a “txt” extension. Rename to “DABatch.cmd” after downloading.
The usage from the command line is:
In January I attended (review) Nick Webster’s “Web Development for Qlik Developers” course. I found the course extremely valuable so I’m bringing Nick to San Francisco September 19-22 for a four day fast track course.
Summary: QV12 no longer prints the REM statement to the Document Log.
In QV11 “//” and “/*” comments do not appear in the Document Log, but “REM” comments do appear in the log. I found REM useful to provide some documentation in my logfile or record which branch was taken in an IF-THEN-ELSE.
QV12 has changed the logging of REM. The REM statement will now appear in the log obfuscated as a series of asterisks For example, the statementREM Beginning of weekly load;
will appear in the log as
When I started with QlikView (V7), we sometimes wanted to operate on data other than the current selections. We accomplished this with the ALL keyword and complex if() functions. It usually did the job but slow, resource intensive and frequently complex to code.
Along came Set Analysis in QV8.5. Brilliant! Performance problem solved!
We still wanted to do comparative analysis, something not directly supported by Set Analysis. So we resorted to loading fields a second time in a data island. Once again, slow, complex if() functions.
Like Karl Pover, I’m curious to learn more about writing Qlik Sense extensions and other opportunities to use the Sense APIs. I’ve created some throwaway examples in class, usually working directly in the Sense/Extensions directory.
Summary: The Dual() function stores both string and numeric representations of a value. “Implied Duals” such as Dates, store only the numeric portion and apply the string mask as needed. In some circumstances such as un-optimized QVD loads, implied duals can get converted to “full duals” using storage unnecessarily.
In QlikView and Qlik Sense you can create a Dual field using the Dual() function such as:
When comparing Qlik Sense to QlikView, the most obvious differences are on the front-end, with its completely overhauled and fully responsive design. Other major differences are the server-based development, the use of Master Items and the shift towards APIs, mashups, extensions and widgets.
The 2017 Magic Quadrant for Business Intelligence and Analytics Platforms has been released and Qlik is in the Leaders quadrant for the 7th consecutive year! Besides Qlik, both Tableau and Microsoft return in the Leaders quadrant, where they also were last year.
I’m midway through Alberto Cairo’s new book “The Truthful Art” and finding it very stimulating. It’s an interesting time to be a data scientist, journalist or consumer of data.
“The Truthful Art” encourages us to use data truthfully and fearlessly, and provides processes and principles to do so.
I just finished the four day “Web Dev for Qlik Dev” course with Nick Webster of Websy.io. I rate the course Excellent!
Summary: QlikView OnOpen Document triggers fire after the saved opening sheet is calculated. That sheet may have some heavy calculations that slow the user’s opening experience.
Maybe you already know this, maybe not.
I commonly use a Document OnOpen trigger to make sure that my Document opens on the correct sheet. I do this because I can be lazy or sloppy during development and save the document with the wrong sheet open. What ever I saved with becomes the opening sheet. I hate to reinstall an app just because I saved on the wrong sheet.
In my consulting practice, I’m frequently engaged to improve the performance of one or more QlikView applications. In addition to an improved application, I typically deliver a report of measured improvement and what was changed to achieve the improvements.
In an earlier post I wrote about how to authorize the script Execute statement, and the differences between QlikView versions 11 and 12. I’ve just tested the new QlikView v12.10 Initial Release, and the rules have changed again.
To run an Execute statement in QV12 Desktop requires that “User Preference, Security, Script (Allow Database Write and Execute Statements)” be checked on. This is also true in QV12.10.
QlikView Components (QVC — should we rename it to “Qlik Components”?) documentation is now available in a Qlik Sense QVF format. You can download it from github here:
After downloading the “QVC Documentation.qvf” file, you’ll need to copy the file to your Qlik Sense apps folder or drop it on Qlik Sense desktop window to view.
Have you ever thought it might be interesting to store a Qlik data model into a single QVD? This can be useful in a number of cases such as:Archiving (and retrieving) data models. Overcoming the “single binary load” restriction.
QlikView Components (QVC) Version 11 introduced two new routines to do just that:
Qvc.ExportModel — Exports all tables of the current model into a single QVD.
Qvc.ImportModel — Import a data model created by Qvc.ExportModel.
Summary: I provide a tool to check your script for compatibility with QlikView version 12.
I’ve blogged about a couple of script changes in QV12 here. Since then I’ve also noticed that the $(include) statement is also affected by the Directory statement. That is, if the script below works in QV11, it will not work in QV12:
Summary: I suggest a simpler syntax for merging selections from multiple states.
You may be familiar with the “Product Grouping” example from the “What’s new in QlikView 11.qvw” sample. It’s a great beginner demo of using Alternate States for comparative analysis.
Summary: I show a scripting technique to assign display formats to loaded data without touching existing load statements.
I coded in SAS for many years and always appreciated the FORMAT statement which allowed me to declare a display format for a field, independent of loading the field.
Join us at the free QDG event in SF on June 28 from 5:30pm to 8:30pm. The easy to access location is 44 Montgomery, same building as Montgomery BART.
We’ve got a great lineup in store with David Freriks of Qlik talking about the latest big data strategies, Patrick Vinton of QlikMaps showing off some innovative GeoSpatial analytics, as well as community presenters Gerry Castellino and Rob Wunderlich covering data heirarchies and automated testing. The full program can be viewed here.
Have you noticed something new in QlikView12 and Qlik Sense timestamp parsing? UTC timestamps are automatically understood.
(Note: the output displayed below utilizes the US Date format set in the script as: SET TimestampFormat=’M/D/YYYY h:mm:ss[.fff] TT’;)
For example, the expression:=Timestamp('20160504T142523.487-0500')
returns:5/4/2016 7:25:23 PM
That is, the UTC offset of “-0500” is detected and the returned value is the UTC time, not the local time of 2:25:23 PM.
Note: Please disregard an earlier version of this post titled “Scaling Numbers”. That was a misprint, this is the complete post.
Summary: I demonstrate a simple reusable expression to auto scale numbers in QlikView. This leads to an exploration of some of the finer details of dollar sign expansion.
Summary: While preceding load is a powerful tool, the current performance penalty may cause you to reconsider using it for anything but the smallest of data sets.
I’m a big fan of the “Preceding Load” feature in Qlik Script. This is the facility that allows us to stack a LOAD statement on top of a SQL statement, or stack two or more loads to simplify coding.
Last week the Masters Summit for Qlik was held in Milan, Italy. For those unfamiliar with the event, the Masters Summit is a 3 day advanced training for QlikView and Sense developers. If you have followed all the Qlik trainings (Designer, Developer, etc.), have 1 to 3 years of experience and ask yourself “Now what?” then this training is perfect for you.
Have you been to a Qlik Dev Group meetup yet? Why not? The meetings are free and take place all over the world. At QDG high quality Qlik speakers like Henric Cronstrom, Donald Farmer and Alexander Karlsson offer insight and details of Qlik products. Community presenters like Richard Pearce and Brian Booden offer development tips and show off wow extensions.
It’s a place to share technology, practices and tips in a non-competitive, no-selling environment.
While most QlikView Designers are familiar with the works and principles of data visualization gurus such as Stephen Few and Edward Tufte, when it comes to dashboard layout many (including myself) are more likely to follow the design principles of that other visualization expert: Bob Ross.
I was chatting with a colleague recently about trends in BI and I brought up what I call the “commoditization of metrics” . Google Analytics is an early example of this — your data crunched and delivered at the KPI level.
I recently ran across a great example of the commodity metrics idea: Yoke.io.
Yoke let’s you build your own dashboard using metrics gleaned from cloud services such as Gmail, Twitter and Github. Here’s a portion of my Yoke dashboard. It’s all built with a few clicks and no coding.
Summary: Selections can be made in Calculated Dimensions, although the result may not always be what is expected or desired. The Aggr() function can be used to control what field(s) get selected.
The technique discussed in this post applies to both QlikView and Qlik Sense. The screenshots shown are from QlikView. Some of the visuals are a bit different in Qlik Sense, but the idea and expressions demonstrated are the same.
There are a number of reasons you may want to upgrade to QV12, I’ll be posting about them in the next few weeks. Today’s post is specifically about what you must address to upgrade to QV12.
There are two items I’m aware of that you must be aware of and consider before upgrading.
Summary: QV12 introduces a “breaking change” in how file paths are interpreted by QVD File functions like QvdNoOfRecords.
In QlikView version 11 script, the five QVD file functions were not impacted by use of the Directory statement. Relative paths given to these functions were always relative to the qvw file, not the current Directory setting. This is different than the other file functions like FileSize() which considered paths to be relative to the current Directory setting.
Summary: QV Version 12 removes per qvw control of the script EXECUTE Statement. In QV12 Server, the default is to disallow all EXECUTE statements. Any EXECUTE statement will fail unless you turn on the global setting to allow.
The QlikView script “EXECUTE” statement provides the capability to run external programs from script. Because EXECUTE may present a potential security risk, it’s use must be authorized. QlikView Version 12 changes how EXECUTE authorization is granted.
The Masters Summit for Qlik begins it’s fourth year with a date in Milan, Italy on 5-7 April. The Masters Summit is three days of advanced training designed to take your Qlik skills to the next level.
Designed for Qlik Developers who have basic skills and experience, the Summit presents three days of intense hands-on sessions in topics such as Advanced Scripting and Data Modeling, Advanced Aggregation and Set Analysis, and Visualization Techniques.
I like using “Show Frequency” in a Listbox, but the feature suffers two drawbacks.If the Field is in a Dimension table, the frequency — usually 1 — is not particularly useful to the user. Excluded (gray) rows show a blank frequency value.
As an alternative to “Show Frequency”, we can use the Expression pane of the Listbox to provide a more meaningful number, such as count of orders.
Using dimensions on the X and Y axis and plotting measures at the intersection is a useful visualization. The out of the box solution in QlikView is the Grid chart.
The grid chart does have limited options for representing data.
The Pivot Table can be a more robust alternative. A Pivot Table grid (Crosstable) is created by dragging one of the dimensions to the horizontal position.
The good folks over at Packt Publishing are having a special promotion on our book QlikView 11 for Developers until November 25th 2015. Now is an excellent time to get the book if you:
One of the reasons why I like QlikView so much is that there are always new functions and applications to discover. Yesterday I was at a client who is a Qlik OEM partner. During lunch we discussed various uses of include scripts. The question came up if it was possible to remotely update include scripts.
Last Thursday I did a presentation at the Qlik Dev Group NL about QlikView macro’s. While the title Macro’s are bad! suggests that I have a very firm view on macro’s, of course the actual presentation is much more nuanced. I wouldn’t be talking about macro’s if I didn’t think they have their uses
It’s been quite a while since my last post. Summer vacations, Masters Summits in New York and Copenhagen, a Luminary meetup in Lund. Lots of new input for blogging.
I’ve been testing the QV Version 12 Beta and am pleased to see a few simple but useful enhancements in bar charts.
Last month I wrote about error handling changes in Qlikview SR11. Today I want to relate my experience in using the new “SilentErrorInChart” switch during development.
Let’s start with an excerpt from the SR11 Release Notes:
Qlik won’t be holding a user conference in 2015. Why not spend your training time with us at the Masters Summit for QlikView in New York or Copenhagen this fall? In three days of intense hands on training you’ll take your skills to the next level and come home with the knowledge and tools to advance your company’s QlikView program and resolve those knotty problems.
If you are a regular reader of this blog, you are probably aware of the Masters Summit for QlikView.
This is the first blog post at the new home of this QlikView blog, previously known as iQlik and hosted at http://iqlik.wordpress.com. After more than one year without posting any content, I’ve decided to continue my commitment to sharing QlikView ideas, tips and experiences and merge the iQlik blog content into the site of my consulting company, AfterSync.
As you may have read here before, besides blogging at QlikFix I also participate in the Q-On Training Center. Q-On offers focused, online instructor-led trainings that dive deep into specific QlikView and Qlik Sense subjects.
Well that’s a wordy title isn’t it?
I’m in the midst of writing a new QlikView Document Optimization course to be delivered at Q-On Training . This work has reminded me of a not-so-obvious issue I sometimes see in Performance Tuning engagements with customers.
You might be thinking I’m going to write today about how heavy a calculation can be as a result of the cartesian product of disconnected fields in an expression . No…that’s not what I’m thinking of.
I’ll be leading a 3.5 hour training June 4 on using the free open source “QlikView Components” scripting library. The training is held on-line and you can find out more and register at this link on the Qlik-On website.
QV Developers around the world use QVC in their scripting to:
SR11 introduces two changes to error handling that you should be aware of.
The first change is that syntax errors marked with the “red squiggle” in the expression editor will always generate a status message of “Errors in expression”. This was not the case prior to SR11.
In SR10 and prior there could be a difference of opinion between the red squiggles and the status message. Valid syntax such as this–
Bill Lay showed this one in his Tips & Tricks session at the “Masters Summit for QlikView” in San Francisco.
How do you show a currency symbol on chart y-axis values? It requires two steps:
1. Assign the format, like Money, in the Number format.
Last month I made an appeal in this blog for developers to run a tool that would scan QVWs and contribute anonymous data to a study. Sixty one sites have submitted data so far. As promised, I’m making the results available for download and analysis here.
Every software product has it’s bits of tribal lore, those unintuitive quirks that when revealed make you say “aha!” and feel empowered to mentor others.
A QlikView factoid of this variety is that: “General Script Error” from a script STORE statement usually means that the target directory does not exist. For example, a “General Script Error” from the following statement if “somedir” does not exist:
Last week my Masters Summit colleague Kevin McCann showed me a cool technique for generating popups (hover text) in individual cells of a Straight or Pivot Table. This can be useful for providing contextual info like order line detail:
I was recently working with a customer developing training curriculum and the question was asked “what expression functions do developers use most”. I thought it was a question worth getting a specific answer to. So I’m creating a community project to gather data on what QV functions and features people use.
Today I am going to let you in on a big secret.
People often ask me how I always get great performance and fast response times out of my QlikView applications. I usually put on a very serious face and reply that this is the result of years of experience. Experience gained by doing hundreds of implementations, practice, experiment, study and continually refining my skills and knowledge.
Since Twitter’s Bootstrap library is very famous and common nowadays it’s quite natural that you might want to use Bootstrap styles within your Qlik Sense visualization extensions.But …
If you just start straightforward and try to load Bootstrap’s CSS (which can be downloaded from here), you’ll not be that happy because something definitely unwanted happens. The styling of Qlik Sense completely crashes because of CSS conflicts respectively Bootstrap’s CSS is overruling some of Qlik Sense’ CSS styles:
I have just published a customizable Funnel chart Visualization Extension for Qlik Sense:
During my internship at Bitmetric one of my project goals was to build a QlikView application to benchmark logistical companies. I needed to visually compare the results of one organization with the average results of all organizations. My first try was using a combo chart with symbols, but I wasn’t happy with how that looked:
This is the port of my Calendar Heatmap Extension to Qlik Sense.
As you might have guessed from some of my earlier posts, I am a sucker for popular culture from the 80’s and 90’s.
As you may know, we offer online QlikView and Qlik Sense trainings through the QlikOn Training Center. These trainings are short (4 hours max), instructor-led and focus on a single subject which will be covered in-depth. With small groups there is enough opportunity to ask as many questions as you like. A perfect way to increase your skills and knowledge.
For January 2015, we are offer the following trainings:
Christmas time is near again, so it’s time for another visual effect in QlikView: the QlikFix 2014 Christmas Card. Using the trusty animated scatter plot once more, I’ve built a little spinning Christmas tree (and, in the spirit of Christmas, added some awful music ). Check the video below:
The complete QVW can be downloaded below:
Different people have different preferences for acquiring new skills and knowledge. Some like to follow a classroom training while others prefer to start with a concrete problem, research the subject themselves and learn by doing.
I have created this tool for my daily work. Instead of always reinventing the wheel and setting up a project structure for Qlik Sense Extensions, I prefer to let it generated.
Project Site: https://github.com/QlikDev/generator-qsExtension
A little while ago, I was asked to change an existing QlikView Application. While scanning the application, I found that it used Alternate States. I had already heard about Alternate States, and that they could store different user selections, but didn’t have any hands-on experience yet.
The multibox is a QlikView object that I find extremely useful because it allows you to fit selection fields into a much smaller space. At the same time, I also find it extremely annoying; the gradient looks dated and if you want your field names and values to be readable you will often have to make both columns quite wide.
As someone who often has to look at/modify QlikView script written by others, I have come to appreciate the value of readable script. Rather than taking an “if it works, it works” attitude, I always try to write my script with readability and consistency in mind. Somewhere down the line someone else (or worse, you) might have to decipher what a specific script is doing in order to modify or extend it.
A very short tip on writing QlikView expressions that might save you a lot of headaches. In my last online training on Set Analysis (another one coming up this week) I showed a simple technique that I use when writing expressions in QlikView, especially when they contain nested functions.
Two questions from business users that will probably sound familiar to most QlikView Developers:
“We currently use this report. Can you re-make this in QlikView?”
“Our graphics designer came up with this dashboard. Can you do that in QlikView?”
Quite often you’ll find the answer to be yes. Although admittedly, you often may also want to suggest another approach, especially when asked the first question.
Recently I was asked if the following chart could be built in QlikView:
One of the reasons I started this blog in 2010 was not only to share what I know about QlikView, but also to expand my own knowledge and understanding of it. In my opinion, explaining concepts and solutions to others is a great way to identify areas of improvement for yourself.
Today I read a very interesting blog post about the QlikView Cache by Qlik’s Henric Cronström (HIC). In the post, Henric gives a high level overview of how caching is used within QlikView to speed up front-end response times.
I hope will see you there – I’m sure it will be fund, and I am really lookking forward to see the results at the evening on Sunday!!!
BTW, I’ll also show you some new nice QlikView.Next related examples – if you like …
I often need random data. For example to use in an example file on this blog, to deliver a customer demo or just to test out something new. As I am probably not the only one with this need, here’s a short and sweet post on how to generate random data for use in QlikView.
I recently read an interesting post by James Richardson over at the Business Discovery Blog: Wizards vs Scripts. In the post James makes the case that QlikView scripting is not old-fashioned or too hard, but is evidence of the power of QlikView as a platform.
In the last months I have received quite often the request to add a new feature to my WebPageViewer2 extension (you could even say it’s a bugfix): The extension did reload the web page on every QlikView refresh event (e.g. making any selections), even if the Url of the web page did not change.
Some weeks ago the chart type “Slope Graph”, invented by Eward Tufte in 1983, was first brought to my attention.
When I first saw it I thought that it would be quite easy to bring this chart also to the QlikView world. But after some research I realized that Slopegrahps have some drawbacks which are quite tricky to solve.
I have recently published a free calendar heatmap extension to compare values on a day-per-day basis over a long period of time (several years). The extension is developed using D3 and an existing visualization called “Calendar View” by Mike Bostok.
The data passed to the extension is displayed in a diverging color scale. The values are visualized as colored cells per day. Days are arranged into columns by week, then grouped by month and years.
To be honest, I’m a little bit frustrated when talking about open-source development for QlikView. For quite some time I am trying to share as much content as possible and the response/feedback is little.
For a long time I was thinking that maybe I am just developing solutions which are not used/needed by customers and partners, but the last months have shown me that the reality is different:
OK, it’s now time to stop with theory and start coding. We’ll create our first “Hello World” extension.
The concept of QlikView Extensions has been introduced with QlikView 10 and improved with QlikView 11+.
I have uploaded a QlikView Document Extension which enables you to add the ability to a QlikView application that its UI will be refreshed automatically every X seconds.
I have developed this extension some months ago and it is already used by quite a lot of customers and partners who are using this extension for example for monitors in a production line.Download + Documentation:
From October 9 – 11 and from October 14 – 16, the European edition of the Masters Summit for QlikView was held in London and Barcelona. The goal of this event is to show and discuss advanced concepts, methods and techniques for QlikView development and deployment through 3 days of hands-on sessions and discussions.
Welcome to QlikShare.Com.
In this video, I’ll quickly explain you about the scope of variables. Qlik variables are interesting because of dollar sign expansion ($).
I had it coming, but yesterday it finally happened; the QlikFix website collapsed under its own success. With visitors and page views steadily increasing I had outgrown the cheap ‘n cheerful hosting solution that I’d been using for the past 3 years.
Since its publication in November 2012, our book QlikView 11 for Developers has been used by many people to take their first steps in QlikView, improve their skills and prepare for their Developer certification.
Welcome to QlikShare.Com. I’ve not posted for long time, sorry! I’ve been busy with work & personal things. I’ve promised myself to post more frequently.
In this video, I’ll quickly show you – how not to suppress rows in Pivot Table while making selections. I’ve used simple Set Analysis expression and also changed the chart properties.
This article demonstrates how you can combine several objects from multiple QlikView applications into a single dashboard (Executive Dashboard).Motivation
From a performance and manageability perspective it absolutely makes sense to segment your data, to split up different analysis aspects into several applications. This is the basis of QlikView’s App approach.
The “WebPageViewer” extension which will be installed with the QlikView installation (C:\Program Files\QlikView\Examples\Extensions\ExtensionExamples.qar) contains a little bug. That’s why I have created a new QlikView extension called “WebPageViewer2″ with some little improvements.Purpose of this QlikView Object Extension
The purpose of this QlikView extension is easy to describe: Integrate an existing web page into an existing QlikView application by just defining the Url of the web page.
This article demonstrates a custom solution how to pre-select a category in QlikView AccessPoint. The pre-selected category will be opened by default, but the user still has the possibility to change the category by using the category select box (which is the default behavior of QlikView AccessPoint).Setup
Follow these steps to customize your QlikView AccessPoint:
The QlikView Management Services API (QMS API) is an officially supported web service based API to get access to functionality behind QlikView Server and QlikView Publisher. Using the QMS API everything which can be done within the QlikView Mangement Console (QMC) can also be accomplished programmatically (and much more!!!).
In my opinion the QMS API is the most beautiful API QlikView offers (probably because it is one of the newest ones …). But at the same time I only see a few partner solutions available using the possibilities of this API. Really wondering why!
The Animated Scatter Chart Extension is based on the excellent charting library D3js.org and a recreation of Gapminder’s Wealth & Health of Nations, made famous by Hans Rosling’s memorable 2006 TED talk, by Mike Bostock.
I recently received the request from a colleague if the following animated scatter chart published on GapMinder could be realized with QlikView Extensions.
This article demonstrates how to overcome some limitations of the standard Current Selections Box of QlikView: Translating field values, translating “hardcoded” labels of the Current Selections Box, hiding specific fields and customizing the icons shown.
The solution is based on a QlikView object extension I have created, called “Better Current SelectionsBox”.
Creating Mashups in QlikView is extremely simple but I am very often surprised that QlikView’s ability to integrate QlikView documents and objects into other web application is not used very often, sometimes it is not even known that this can be achieved easily.
Maybe one reason for that is that documentation and examples are very rare. That’s why I have created a very detailed documentation + examples which I am publishing now.What are Mashups?
A definition from Wikipedia:
It is quite easy to reload a current QlikView document if you are using the IE-Plugin or QlikView Desktop. But achieving the same result if you are using the Ajax-/Web-/Mobile-Client is a bit more demaning.
The solution described here closes the gap using a combined approach of misc. QlikView integration techniques:
It’s all about User Experience (Thanks to Paul Veugen)
Logical Processing (Thanks to Simon)
This is the second part on QlikView Joins. In this part, I have covered Inner Join in QlikView, Logical Understanding of the Inner Join and using Venn diagram.
Basic rules of Joins:
I have already posted my favorite cheat sheets for jQuery. Today here are my favorites for CSS3 (Cascading Style Sheets v3):Cheat Sheet by CSS3.com
Online cheat sheet by CSS3.com with a comparison to CSS1 and CSS2 plus a direct link to the CSS reference on W3C.org.
In the last few weeks I have dedicated quite a lot of time to extension development in QlikView. Doing so I have certainly reviewed existing extensions to get new ideas and study existing code. Unfortunately there is no central repository available where you can find all extensions.
So I thought it would be helpful to share my collection of existing extensions.
When developing QlikView extensions you will probably use jQuery, too. jQuery is also used by default by the QlikView Ajax client so jQuery is available out of the box. For all QlikView Extension developers who are not working with jQuery every day these cheat sheets may help:Online Cheat Sheet:
I like this cheat sheet most, because you are able the select the desired jQuery version and all entries are linked with the official jQuery documentation.
I have tried several ways and editors to develop QlikView extensions. But finally I have found a good and easily to set up way using Visual Studio.net 2010.Why Visual Studio
Maybe you are asking why I am using Visual Studio although a “normal” editor would be absolutely enough.
In the recent months I have seen a lot of QlikView applications where QlikView developers & designers have used layout techniques in combination with “Show Conditions” to enable the feeling to have a control that allows the user to change the state of a variable. This technique works, but it is always a little bit tricky to set up and is time consuming.
So I have created a QlikView object extension which encapsulates the logic describes above, I have named this extension “OnOffSwitch”.
Just wanted to point you to a very insteresting article by Stephen Radmond from “Qlik Tips”.
He explains why it absolutely makes sense placing list boxes and selections in general on the right side of the screen … especially if you are designing your QlikView applications for an iPad.
There are many scenarios where it is necessary to process QlikView data with other systems. There are many approaches and examples available how this can be achieved using Macros (based on the QlikView IE-Plugin) but this article cover how you can realize such a requirement by using only the QlikView Ajax client.Scenarios
Let’s first talk about some of the scenarios where passing data from QlikView to other systems is necessary. Just some sample requirements:
I recently came across some projects with some special layout requirements. While it would certainly be possible to create a separate QlikView extension for every requirement I wanted to find a more generic an reusable approach for rendering QlikView content.
The goal was to bring some capabilities into QlikView (using an extension) which makes formatting data as simple as possible, ideally as simple as if you format a web page.
As a reference point I took the visualization of a very complex web-page like amazon.com.
By default you are not able to access sub directories within your QlikView extension. But especially when developing more complex QlikView Extensions organizing your files in directory is really helpful (and necessary).
With a little trick you will be able to access sub directories:
Recently the QlikView Governance Dashboard has been published and is absolutely worth to be reviewed a little bit …What is this “QlikView Governance Dashboard” for?
If you already know the Metadata Powertools published on QlikCommunity you’ll find some of the existing concepts in “QlikView Governance Dashboard”:
QlikView 11 SR2 has been published today (Built 11414).
The most interesting news on QlikView 11 SR2:
With this release also “Offline Views” or “QlikView Offline Capability” for iPad, so the ability to browse data on iPad offline, has been added to this release …
More news on that this evening soon …
In one of my previous posts I explained how to enable the automatic integration of current selections within the Excel-export of QlikView Desktop or QlikView IE-Plugin.
I received a lot of eMails how to force this for the Ajax-Client and/or Mobile-Client, here’s the answer:Setup for QlikView Server
Open the settings.ini file for your QlikView Server.
This file is located at
After the last post I received some eMails how to deploy QlikView Extensions.
Altough this information is already available somewhere in the QlikCommunity here is the short instruction.
If you have downloaded a .qar (QlikView Archive file) it is easy to install this file for later usage within the QlikView Desktop:
Just doubleclick the file and QlikView will be started automatically showing you the confirmation dialog that the .qar file has been deployed to your local computer.
By default QlikView’s TextBox object does not interpret Html content. It will just show the full Html code loaded into the TextBox object. This also does not change if you are using the WebClient (Ajax client or Mobile client).
Starting with Windows 7 there is not included any SMTP/POP3 service in the local IIS (Internet Information Server) anymore.
So there is no way to present some of the QlikView Server/Publisher’s features on your local PC without being dependent on an external SMTP-server.
QlikView’s QMSAPI offers the method IQMS.FindEDX which returns all EDX tasks matching the given name.
If you have a look at the detailed explanation of this function it will return any EDX task containing the value for the given string:
Do you normally succeed CREATING and DOCUMENTING a Set Analysis expression/formula like the following one in less than two minutes?
I do normally not! And even if I would, after two weeks I cannot remember why I have created this statement like this …
In the past it was not possible to load a mapping table directly from a QVD file. We had to use some workarounds to break the optimized load like:Mapping_Map: Mapping LOAD Field1, Field2 FROM qvdFile.qvd (qvd) WHERE 1=1;
orMappping_Map: Mapping LOAD Field1, Field2, 1 as Field_temp FROM qvdFile.qvd (qvd); DROP FIELD Field_temp FROM Mapping_Map;
just loading the fields to a temporary table and then using a RESIDENT LOAD.
This is the second part of the series of articles summarizing some hints for working with the QlikView Designer. In this part I’ll show you what you need to know about “Moving/Copying objects” in QlikView.