• Mid-Week Humor with the Marketoonist

    Over the next few weeks we will be posting weekly 'funnies' by the Marketoonist. Each one has a humorous take on BI or Business Information in the corporate world. We hope you enjoy them   Here's this weeks: ...
    Sara Leslie
    last modified by Sara Leslie
  • Disable selections in charts using Capability APIs

    UPDATE -  There is no longer any reason to do it this way. Beginning with Qlik Sense 3.0, we now have the noSelections option - App API and Viz API noSelections option.     I've come across the need a ...
    Francis Kabinoff
    last modified by Francis Kabinoff
  • App API and Viz API noSelections option

    Sometimes you may want to use a chart in a mashup that does not allow selections. Before Qlik Sense 3.0, you basically had three options. One of those options I blogged about before Disable selections in charts using ...
    Francis Kabinoff
    created by Francis Kabinoff
  • Aggregations and Function Classes

    A typical QlikView application may have one million records in the data, one hundred rows in a pivot table and a single number, a KPI, in a gauge or text box. Although different in magnitudes, all three numbers may st...
    Henric Cronström
    last modified by Henric Cronström
  • The Qlik Continuous Classroom

      Have you subscribed to the Qlik Continuous Classroom (QCC) yet?!    If not we recommend you visit the Qlik Continuous Classroom and watch the free modules to learn everything it has to offer! ...
    Sarah Miller
    last modified by Sarah Miller
  • FileName Function

    Today I thought I would share how I used a combination of string functions and the FileName function to create data for my app.  I loaded several Excel files with one Load script and generated the data I needed f...
    Jennell McIntire
    created by Jennell McIntire
  • Canonical Date

    A common situation when loading data into QlikView is that the data model contains several dates. For instance, in order data you often have one order date, one required date and one shipped date.     This...
    Henric Cronström
    last modified by Henric Cronström
  • The As-Of Table

    Last week I wrote about how the Above() function can be used for calculating rolling averages and other accumulations. There is however also an alternative method for doing the same thing: The As-Of table.   ...
    Henric Cronström
    last modified by Henric Cronström
  • Loops in the Script

    Iterations – or loops – are constructions where a set of statements are executed zero or more times, until some condition is met. They are very common in all programming languages, and QlikView scripting i...
    Henric Cronström
    last modified by Henric Cronström
  • Qlik Sense - QMC Utilities

    Today - Jeff Goldberg is back as our latest guest blogger and will introduce us to Qlik Sense QMC Utilities. Jeff is a Senior Enterprise Architect on the North America Enterprise Architecture team who has worked in va...
    Michael Tarallo
    last modified by Michael Tarallo
  • Como obter ajuda? Leia antes de postar

    Estou em encrenca  Como qualquer um de nós você chegou a um ponto que não consegue avançar. Está parado já a alguns minutos (ou horas, ou dias) em um problema aparentemente...
    Clever Anjos
    last modified by Clever Anjos
  • String Functions

    QlikView is full of functions that can be used in expressions and/or the script to manipulate and parse the data.  I decided to write about some common string functions that can be very helpful:   Subfield(...
    Jennell McIntire
    last modified by Jennell McIntire
  • Version Control and Qlik Sense

    "The first time I started to use Qlik Sense it amazed me how easy it is to create powerful great looking apps. The ability to analyze my data was something I never experiences before and I noticed several area's of ap...
    Jeroen Gerritsen
    last modified by Jeroen Gerritsen
  • Mobile Business Intelligence... History?!?

    In todays world we need insight into complicated questions whilst we are on the move. The phrase, ‘ask Google’ has become common parlance for I don’t know or can’t remember and therefore need t...
    Richard Corbridge
    last modified by Richard Corbridge
  • Getting all data cells from app.createCube()

    As I was working on one of my latest mashups, I had a task, to get all cells with numerous sets of dimensions and measures, with a HyperCube out of Qlik Sense. The worst part is that one of my sets, had a total of 3+ ...
    Yianni Ververis
    last modified by Yianni Ververis
  • Customizable Straight Table

    In many of the demos that I have done, I have added a customizable straight table or ad-hoc report where the user can select the dimensions and measures that should appear in the chart.  This is often helpful and...
    Jennell McIntire
    created by Jennell McIntire
  • Mobile Friendly Horizontal Bar Chart

    In our Qlik Demo Team we are trying to create mashups that are suitable for all devices. This is why we created another version of a Horizontal Bar Chart that we use almost exclusively. This has various options like s...
    Yianni Ververis
    created by Yianni Ververis
  • Join the community for Advanced Analytics Extensions

    Join the Qlik Community for Advanced Analytics Extensions, which is open for all customers and partners. Now you can leverage advanced analytics, including R and Python, from within your Qlik app. Your results are int...
    Daniel Bergqvist
    last modified by Daniel Bergqvist
  • IntervalMatch

    A common problem in business intelligence is when you want to link a number to a range. It could be that you have a date in one table and an interval – a “From” date and a “To” date ̵...
    Henric Cronström
    last modified by Henric Cronström
  • Recipe for an ABC Analysis

    An ABC analysis is a dynamic bucket classification of e.g. products, based on some property, usually the sales number. The best products are your "A" products and the worst are your "C" products. It is used in all...
    Henric Cronström
    last modified by Henric Cronström