• Melhores Práticas – ApplyMap

    Fala pessoal, tudo bom?   Quero continuar comentando sobre melhores práticas para QlikView e neste capítulo vou falar um pouco sobre a função Applymap.   A função Applym...
    Yuri Nicolett
    last modified by Yuri Nicolett
  • The Search String

    One of the strengths of QlikView is its search engine. With it, you can find pieces of information in a fraction of a second and select the found field values. But how is the search defined? And where can the search b...
    Henric Cronström
    last modified by Henric Cronström
  • Mapping as an Alternative to Joining

    Some time ago I wrote a blog on Mapping functions and described how they can be used to replace or modify field values when you run the script.  But how do you know when to map versus join the data in your data m...
    Jennell McIntire
    created by Jennell McIntire
  • Dynamically Selecting Timeframes

    How can a button be used in a QlikView app to dynamically select the last 3 months?  I was asked that question a few weeks ago and thought it would make a good blog topic.  It can easily be done and can prov...
    Jennell McIntire
    created by Jennell McIntire
  • Melhores Práticas – Hideprefix ou Hidesuffix

    Fala pessoal, tudo bom? Quero resgatar um pouco sobre o tópico de melhores práticas para o Qlikview e isso inclui a utilização da função Hideprefix. Mas afinal o que é e para...
    Yuri Nicolett
    last modified by Yuri Nicolett
  • Evaluate() Function

    The Evaluate() function is a string function that takes one text string parameter.  If the string is a valid QlikView or Qlik Sense expression then the evaluated result of the expression will be returned.  I...
    Jennell McIntire
    created by Jennell McIntire
  • NEW! Qlik Sense Skills Assessment

    Are you a Qlik Sense power user? How well do you think you know Qlik Sense? Do you want to challenge yourself to see how well-rounded you are with the product? We have the tool for you! We've updated the Skills Assess...
    Bobby Sacco
    last modified by Bobby Sacco
  • Calculated Dimensions

    To make a chart in QlikView – in any Business Intelligence tool, for that matter – you need to have one or several dimensions; entities with discrete values that you use as grouping symbols. But where shou...
    Henric Cronström
    last modified by Henric Cronström
  • Performance of Conditional Aggregations

    In my previous post I compared different methods for making Conditional Aggregations. In it, I claimed that Set Analysis often is faster than other methods, like an If()-function or a multiplication with a flag.  ...
    Henric Cronström
    last modified by Henric Cronström
  • 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
  • Welcome to the newly updated QlikCommunity!

    Welcome to the upgraded QlikCommunity. Thank you for your patience while we were offline making updates this weekend. During your next few visits take some time to check out the new navigation and functionality.  ...
    Sara Leslie
    last modified by Sara Leslie
  • It’s all Aggregations

    I often see incorrect expressions being used in the QlikCommunity forum. Expressions that seem to work correctly – but really don’t…   So, let me make this clear: Calculations in QlikView are ...
    Henric Cronström
    last modified by Henric Cronström
  • The Only Function

    There is a little known function in QlikView that hardly anyone uses and that doesn’t do very much, but still has a tremendous impact on many of the calculations made in QlikView.   It is the Only() functi...
    Henric Cronström
    last modified by Henric Cronström
  • Recipe for a Pareto Analysis

    “Which products contribute to the first 80% of our turnover?”   This type of question is common in all types of business intelligence. I say “type of question” since it appears in many di...
    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
  • Função para Criar Calendário (Utilizando Data existente no modelo)

    Fala pessoal, tudo beleza?No último post aprendemos a utilizar uma função para criação de calendário passando uma data início e data fim, hoje aprenderemos como verificar ess...
    Yuri Nicolett
    last modified by Yuri Nicolett
  • Conditional Aggregations

    Often you need to create conditional aggregations in QlikView, e.g. when you want to create a graph that shows this year’s numbers only, also if there are several years possible.     There are basica...
    Henric Cronström
    last modified by Henric Cronström
  • Use Aggregation Functions!

    On the discussion forum, I often see people posting questions around expressions that don’t work. When looking at the descriptions, I usually find that the reason is that the expressions lack aggregation functio...
    Henric Cronström
    last modified by Henric Cronström
  • Enhancing the User Experience Using Conditional Expressions

    As QlikView developers, one of our main focuses is on the user experience. There are many instances where objects only need to be shown upon the user’s request. An example of this is list boxes (filters). With t...
    Charles Bannon
    created by Charles Bannon
  • Loading Images into QlikView

    As a QlikView developer I am often asked to load images into QlikView. In some instances the images are associated to other data fields and in other instances they are to be loaded in to the application to help convey...
    Charles Bannon
    last modified by Charles Bannon