Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This space offers a variety of blogs, all written by Qlik employees. Product and non product related.
Product Innovation
By reading the Product Innovation blog, you will learn about what's new across all of the products in our growing Qlik product portfolio.
Support Updates
The Support Updates blog delivers important and useful Qlik Support information about end-of-product support, new service releases, and general support topics.
Qlik Academic Program
This blog was created for professors and students using Qlik within academia.
Community News
Hear it from your Community Managers! The Community News blog provides updates about the Qlik Community Platform and other news and important announcements.
Qlik Digest
The Qlik Digest is your essential monthly low-down of the need-to-know product updates, events, and resources from Qlik.
Qlik Education
The Qlik Education blog provides information about the latest updates of our courses and programs with the Qlik Education team.
Recent Blog Posts
-
Design for Reflection
When designing QlikView applications we are constantly striving to create sparkling applications which comply with usability best-practices, have a great look and feel and have charts that justify the purpose of showing data which can add value to the customer’s business. But a lot of times, in spite of checking off everything that we can think of in terms of creating a world class app, the customer is not convinced and app is left on the table f... Show MoreWhen designing QlikView applications we are constantly striving to create sparkling applications which comply with usability best-practices, have a great look and feel and have charts that justify the purpose of showing data which can add value to the customer’s business. But a lot of times, in spite of checking off everything that we can think of in terms of creating a world class app, the customer is not convinced and app is left on the table for us to take back. Maybe then, taking design one step further is what is required to make a full impact.
Don Norman, in his book ‘Emotional Design: Why We Love (or Hate) Everyday Things’ talks about 3 levels of perception. Visceral – 1st stage - how someone perceives the visual aspect of a product, Behavioral – 2nd stage - how the product works, ease of use and ergonomics. Reflective – 3rd level – what does this product say about me. Most often times, we work on the first two aspects, usability of our apps and then making them look good but it is seldom that we think about how our apps reflect the users. Does it suite the image of the customer? Apart from showing all the value that our product brings to them, does it connect with the customer on a psychological, cultural and aesthetic level?
Reflective processing is when our desires for sophistication and to be aesthetically at par with cultural biases influences our likes and dislikes. It is a very common human trait since we live in a complex social and cultural set up. Owning products that reflect positively on our personality is a natural human instinct. For instance, preferring a coffee from Starbucks over an ordinary coffee place not just because you like the coffee but also because it reflects something about your personality and brand consciousness.
According to Norman, designing for reflection is one of the most powerful ways to build long term product-user relationships. Not only does it impacts the user’s perception but also creates a deeper psychological connection and an emotional engagement with the user.
Simple tricks like skinning the QlikView application with the customer’s brand identity can make a big impact on the customer’s perception of the app in a positive way. But influencing someone on a reflective level goes beyond aesthetic appeal. The key is to be user-centric rather than being product-centric.
Here is what some of the successful product strategists have done in order to hit the inner nerve of the customer’s brain.
- Cultural Trends - Studying cultural patterns and trends that exist within the target user group helps in identifying user expectations and preferences. This can help a lot when designing apps that customers can identify with and prefer owning.
- User pain points – Tackling the pain points of the user in the design and then branding the product in a way that orchestrates those pain points and offers solutions to help resolve those can really hit the note. This helps in creating a self-reflection of the user in the product.
In general spending some extra time and efforts to research the target audience and catering to their needs and preferences can create a product that is a reflection of the users and will stand a better chance of appealing to the user as opposed to just being a good looking robust application.
-
Custom Application Training
Custom Application Training helps to increase adoption and return on investment by delivering targeted training designed specifically on your Qlik application. Custom Application Training includes:Targeted eLearning on your Qlik applicationBusiness user-focused videos and reference cardsLaunch Kit, containing communication templates and best practices to help you create a tailored training rollout planTo learn more about the Custom Application Tr... Show MoreCustom Application Training helps to increase adoption and return on investment by delivering targeted training designed specifically on your Qlik application.
Custom Application Training includes:
- Targeted eLearning on your Qlik application
- Business user-focused videos and reference cards
- Launch Kit, containing communication templates and best practices to help you create a tailored training rollout plan
To learn more about the Custom Application Training, please contact your local Education Training Manager.
-
Replacing images with Geometric Shapes as visual cues
The use of icons and other visual cues has been proved as a great value asset in data visualization. Icons let people to better understand complex information. Another good thing about icons is that they let us communicate globally. An up-pointing triangle is universally understood as a representation of growth.QlikView brings you the possibility to choose from a predesigned set of visual indicators.A good alternative to the standard icons is the... Show MoreThe use of icons and other visual cues has been proved as a great value asset in data visualization.
Icons let people to better understand complex information. Another good thing about icons is that they let us communicate globally. An up-pointing triangle is universally understood as a representation of growth.
QlikView brings you the possibility to choose from a predesigned set of visual indicators.
A good alternative to the standard icons is the Unicode Geometric Shapes set.
“Unicode is a computing industry standard for the consistent encoding, representation and handling of text expressed in most of the world's writing systems.” (Source Wikipedia).
Geometric Shapes is a set of visual indicators that effectively work as a text character. This means, you could use it everywhere you can write text in QlikView. Text objects, captions, cells, sheet titles, etc.The main advantage of using Unicode Geometric shapes over images is the fact that you can control their properties, like size and color as any other text character. You could, for example, set up an expression to change the color based on an expression.
Another good example of how to take advantage of Unicode Shapes is including them as a part of number format pattern. You can predetermine how the shape will look for positive and negative values.
▲ #,##0.0%; ▼ #,##0.0%
Using this pattern will let you integrate an icon inside a cell like as in Change column in the table below.
Color is, in some situations, not enough to differentiate from one state to another. Using different fills or patterns will help color blind people to identify differences.
To include any of these shapes into your next QlikView project you just need to copy the shape from here and paste it where needed.
0
1
2
3
4
5
6
7
8
9
A
B
C
D
E
F
U+25Ax
U+25Bx
U+25Cx
U+25Dx
U+25Ex
Note: Remember to test your app to make sure it renders properly on every possible browser.
Enjoy Qliking!
AMZ
Update: Here you can get a working app with some examples on how to use these shapes.
-
Performance and Scalability - New course offering!
Performance and Scalability – New Instructor-Led CourseThis technical course that gives students the information, tools, techniques and exercises to become knowledgeable in theplanning, analyzing, designing and testing of an optimal QlikView platform.This includes topics dealing with:Application design and architectureHardware configurations and environmentUsage, load testing, and analysisRegister Now! -
Are you QlikView Power User?
Take a QlikView Skills Assessment today to find out if you have all the knowledge you need to effectively design, develop, administer and manage QlikView. -
QlikView SAP Connector 5.80 SR3 is now available
Hello QlikView users,We are pleased to announce that R&D have now released Service Release 3 of the SAP Connector v5.80. The installation files are now available on our download site http://www.qlik.com/download.Details as follows:All Connectors: Backward compatibility towards SAP code starting from the SAP code of release 5.80 SR2. That makes it possible to install the Windows part of the Connectors for a new release without installing the co... Show MoreHello QlikView users,
We are pleased to announce that R&D have now released Service Release 3 of the SAP Connector v5.80. The installation files are now available on our download site http://www.qlik.com/download.
Details as follows:
All Connectors:
Backward compatibility towards SAP code starting from the SAP code of release 5.80 SR2. That makes it possible to install the Windows part of the Connectors for a new release without installing the corresponding SAP transports. However new functionality dependent of changes in the SAP code cannot be used in that case.
Extractor Connector:
- Records for failed ongoing jobs (job status ‘S’) can now be either deleted or job status set to ‘A’ (aborted) from the Connector instead of from the SAP GUI. Be careful not to delete ongoing successful jobs as they are also shown in the new Connector window.
- Improvements when using ‘Message Server Host’ and ‘Group’ in the ‘Setup SAP Connection’ dialogue.
- Improved automatic resend functionality for tRFC transfer method.
Bugs corrected in version – 5.8 SR3
Extractor Connector
- Status table record now gets job status changed to ‘A’ (aborted) when a job is cancelled due to a timeout.
- Extractors with rows containing more than 1000 characters could get corrupt contents in fields. This is now corrected.
- A serious error occurred sometimes due to max no of 100 conversations exceeded. This will not happen anymore.
A big thank you to Dean and the SAP team!
regards,
Global Support Team
-
QlikView in the Enterprise - New free self-service course!
QlikView in the Enterprise is a 45-minute, eLearning course which covers considerations for an IT department to implement QlikView as a self-service business discovery platform – both from an infrastructure and process point of view. It also covers the role of IT and the services available to support the implementation. Watch it now!For all of our free eLearning courses, go to our Free Training website. -
Q2 2014 - QlikView Technical Library module available!
The Q2 2014 QlikView Technical Library modules are now available!This quarterly release includes three videos on the following topics:Introduction to Set AnalysisBasic Set Analysis SyntaxMore Set Analysis SyntaxFor access or more information:Customers: View Data SheetPartners: Access VideosEmployees: Access Videos -
Colors, States and State vectors
The color coding – Green, White, and Gray – is the hallmark of QlikView. These are the colors that convey information to the user about which field vales are selected, which are possible and which are not possible. These are the states. If you think about it for a while, you will realize that there are two different states for each field value: One is the input state; the selection that the user has made – whether the field value is selected ... Show MoreThe color coding – Green, White, and Gray – is the hallmark of QlikView. These are the colors that convey information to the user about which field vales are selected, which are possible and which are not possible.
These are the states.
If you think about it for a while, you will realize that there are two different states for each field value: One is the input state; the selection that the user has made – whether the field value is selected or not; and the other is the output state: whether the field value is possible or not, given the logical inference of the selection.
Two statuses, each with two possibilities. This makes four combinations: Selected possible, Selected excluded, optional and excluded. Hence: There are not just three states – there are four.
“Selected excluded?” you may ask. “How can a value be selected and excluded at the same time?”
It’s simple. It can first be selected, and then excluded by a selection in another field. An example: Let’s say that you have a sales application and you select Jan, Feb and Mar to get the sales for the first quarter. Then you make a second selection – a product that incidentally was sold just in March. This second selection will then of course exclude Jan and Feb from the possible Month values. Jan and Feb will be selected excluded.
The field states are stored in vectors; binary arrays that have the same number of bits as the symbol tables excluding NULL values; the same number of bits as the number of distinct values of a field. There is in fact also a third field state vector that keeps track of alternative field values: the field values that would be possible, had there not been a selection in the same field.
The blue color is sometimes used in QlikView to show whether a field is locked or not. But note that this is not a state – it is a flag for the entire field, and has thus nothing to do with the individual field values.
Finally, there are state vectors for the binary data tables also - vectors that keep track of which records in the data that are possible and which are excluded.
All these vectors are referred to as the state space. The vectors are updated at every selection and used every time QlikView evaluates which symbols to show in an object and which record to include in the calculation. One state space per user and alternate state is created.
This way, the state space vectors keep track of which data is relevant right now – they “remember” the user selection.
PS. All of the above is of course true for both QlikView and Qlik Sense. Both use the same engine.
If you want to read more about QlikView internals, see
Symbol Tables and Bit-Stuffed Pointers
-
3 Color utilities that makes my life easier
We have been talking a lot about color recently. Chuck showed us how to manage colors and alpha transparencies to increase visual perception in our dashboards making it clear for business users to consume charts. A few days before, Apeksha shared some good tips about color usage in QlikView apps. If you are looking for more insight about color and interpretations I strongly recommend you to read Apeksha’s Technical Brief.Choosing the right color... Show MoreWe have been talking a lot about color recently. Chuck showed us how to manage colors and alpha transparencies to increase visual perception in our dashboards making it clear for business users to consume charts. A few days before, Apeksha shared some good tips about color usage in QlikView apps. If you are looking for more insight about color and interpretations I strongly recommend you to read Apeksha’s Technical Brief.
Choosing the right colors.
Colors are present in our apps not only in the charts but also in the backgrounds, tab row, captions, and so forth. It’s key to find a color palette that works and that lets business users consume information quickly and in an efficient way.
There are lots of content and good examples on the internet about color palettes; sites like kuler.adobe.com can provide you with some nice color combinations for your next project.
Some of the most popular color combinations are in colorbrewer2.org. Created by Cynthia Brewer, Mark Harrower and The Pennsylvania State University. It was originally designed for cartographers but it’s a standard in academia for any type of data visualization. (http://colorbrewer2.org/)
I created a QV app (see below) with these colors palettes to facilitate their adoption by our community. Feel free to use, improve and distribute it.
Testing your colors
As discussed earlier in this blog, around 7-8% of world’s population has some short of different color perception. To create great looking QlikView apps you should be conscious that some people out there do not see colors as you do.
To avoid that potential risk that could ruin your app, you could use one of the pre-designed color blind safe palettes and/or you could test your app using a tool that lets you emulate a color blind environment.
Color Oracle is a free color blindness simulator for Window, Mac and Linux. It takes the guesswork out of designing for color blindness by showing you, in real time, what people with common color vision impairments will see. http://www.colororacle.org/
Reading colors
Common tasks are time consuming and when it comes to color it’s very common to find yourself trying to reuse corporative colors. It is probably safe to assume that we all have a color picker tool installed in our machines, but in case you do not... My personal favorite is ColorPix.It’s a standard Color picker tool but it has some features I find it very useful when working with QlikView. I use ColorPix mouse accelerators a lot, that let me copy the RGB value by clicking on the displayed number, then I just need to type RGB( Ctrl+C ) into calculated base color expression box to include the color in my app.
These are 3 small utilities that make my life much easier but, what about you? Are you using any other tool to help you with your QlikView development? Share it with us in the comments!
Enjoy Qliking!
AMZ
Extra: Safe color palettes QV app
-
QlikView 11.20 Service Release 6 Update 1 released
Hi QlikView users,QV11.2 SR6 Update 1 released due to a defect in Hash functions.The hash functions, Hash128, Hash160 and Hash256 have changed behavior from SR5 and with the same input gives a different value in SR6 build 11.20.12347. If these hash functions are used to create concatenated keys to be stored in QVD’s and used in combination with incremental loads this will lead to non-matching keys with older QVD-data created on earlier versions o... Show MoreHi QlikView users,
QV11.2 SR6 Update 1 released due to a defect in Hash functions.
The hash functions, Hash128, Hash160 and Hash256 have changed behavior from SR5 and with the same input gives a different value in SR6 build 11.20.12347. If these hash functions are used to create concatenated keys to be stored in QVD’s and used in combination with incremental loads this will lead to non-matching keys with older QVD-data created on earlier versions of 11.20. If you have already used SR6 to create QVDs according to above, these have to be recreated with 11.20.12354 to match older QVD’s.
We recommend all customers who have installed SR6 upgrade to the new build and recreate all QVD files.
Please visit http://www.qlik.com/download, selecting 11.20 SR6 will automatically show you the latest SR6 Update links.
We apologize for any inconvenience caused and if you have any questions, please do not hesitate to contact support.
regards,
Global Support Team
-
Human Mind and Design
Design in almost every field needs careful consideration of human behavior in order to best fit to human needs. Likewise in the digital world design needs careful consideration of human psychology and behavior. Cognitive psychology forms a big part in the study of user experience design. It helps to know how the human mind works (perception, memory & learning) in order to design interfaces that do not hamper the natural human processes and instea... Show MoreDesign in almost every field needs careful consideration of human behavior in order to best fit to human needs. Likewise in the digital world design needs careful consideration of human psychology and behavior. Cognitive psychology forms a big part in the study of user experience design. It helps to know how the human mind works (perception, memory & learning) in order to design interfaces that do not hamper the natural human processes and instead help in making the digital interactions as easy as possible.
It is imperative to any digital interface to apply design principals and best practices based on usability research. As such QlikView applications also need careful design consideration for them to be seamless or else small usability issues can form big hurdles.
Take for instance the information icon shown below.
What would you gather from this icon? I would think that the icon is a button to get more information and is inactive because of its grey color and very little contrast between the background and text. In most scenarios something that is inactive or non-clickable is shown to be greyed out. But in reality, this icon is active and clickable. So there is a break in the mental model due to an action that is opposite of what the user expects. These are small things to consider but they make a huge impact on the user experience.
The document User-Experience-Guidelines for QlikView shows many such examples, guidelines and best practices to be considered with respect to usability based on principles from cognitive psychology, all of which can be applied to the design of QlikView applications.
In the QlikView world, showing data the right way and making the application usable is important but enhancing the whole experience is the key to a great product. In the words of usability expert Don Norman “It is not enough that we build products that function, that are understandable and usable, we also need to build products that bring joy and excitement, pleasure and fun, and, yes, beauty to people’s lives”.
-
Color Codes
Colors are a very important and critical part of our lives. They not only give meaning to objects but also trigger feeling and emotions within us, influence perspective and affect our psychological being. The study of colors is very complex and a lot has been written and talked about the role and use of colors in various aspects of life. As QlikView application designers, we don’t have to study in depth the meaning and theories of colors but i... Show MoreColors are a very important and critical part of our lives. They not only give meaning to objects but also trigger feeling and emotions within us, influence perspective and affect our psychological being. The study of colors is very complex and a lot has been written and talked about the role and use of colors in various aspects of life.
As QlikView application designers, we don’t have to study in depth the meaning and theories of colors but it is of utmost importance for us to be aware of the usability norms, best practices and social and cultural implication of colors to use them in a conscious and respectful way in our designs and data visualizations. It is very easy to fall in traps of using excessive color variations or inapt color schemes since we have such a wide range to choose from which leads us to falling for temptations of using colors as per our personal likes and dislikes.
A few tips and tricks about how to use colors judiciously can not only help tremendously from falling into these traps that impair usability and deceive the user but also allows datasets to be layered in order to tell eloquent stories. The following guides can be applied to our data visualization for QlikView applications.
1. Use minimal amount of colors in your designs and data visualization. Every application has a focal point or something to highlight. Overly colorful designs can tend to hide the focal point, giving an overall vibrancy to the design and hindering the user from focusing on important points in the data.
2. Using Shades and tints of the same color while showing quantitative information instead of different hues of colors is preferable, like in the pie chart shown below.
However, it is okay to use different color in the same chart when color is used as an indicator of information as long as the colors are limited to 3-5 and color choice is such that they don’t create visual noise. The example below shows how color is used as an indicator of information.
3. Avoid pure gradient rainbow color scales to show data. Because there is no inherent order in the scale, they all appear to come from different families.
4. Keep the colorblind audience in mind when choosing color schemes. Since a large portion of our audience might be colorblind, it is unaffordable to use colors which are not colorblind safe. Color Oracle(http://colororacle.org/index.html) is a good evaluation tool for colorblindness.
5. In places where Red, Green, Yellow have to be used together, introduce other attributes such as icons so that color is not the only differentiating factor. These colors appear similar to colorblind people.
6. When using Red and green together, choose a green which is closer to blue in hue, this way tthe 2 colors can be differentiated easily by the colorblind users.
Apart from the above basic usability guidelines, there are other things to consider while choosing color schemes for designs. Choice of colors is very subjective, however, this not only because of personal preference but can also due to deep rooted cultural and social connotations associated to colors that are imbedded within us. Colors hold different meanings in each culture and we should be conscious of those meaning when presenting to a global audience or a specific country. This way misinterpretations and offensive use of colors can be avoided.
An elaborate insight on colors, their use and interpretations can be found in this Technical Brief.
-
4 Pieces of (basic) Design Advice
The Demos & Best Practices team are often asked to look at applications built by third parties and give feedback. This feedback covers technical QlikView recommendations as well as design & usability best practices. Being on the outside looking in our team tends to approach these apps in ways their developers usually haven't considered. Very often these apps are being built by developers who have been so focused on making sure the data is correct... Show MoreThe Demos & Best Practices team are often asked to look at applications built by third parties and give feedback. This feedback covers technical QlikView recommendations as well as design & usability best practices. Being on the outside looking in our team tends to approach these apps in ways their developers usually haven't considered. Very often these apps are being built by developers who have been so focused on making sure the data is correct they haven't stopped to consider the user experience until they are almost finished.
With that in mind the following are a four pieces of design advice that we tend to give fairly often.
Boxes boxes everywhere.
Many developers leave borders, shadows, and caption backgrounds on their charts and list boxes. These are some of the first things the Demos & Best Practices team remove when we are overhauling an app. When every object is fenced in it makes the entire app look very boxy where all of the objects are their own little entities isolated from the other charts. Even if you aren't convinced by this reasoning the question we would pose is "how are these borders, shadows, etc. helping the app?"
No 3D charts … ever.
Like something out of Mommie Dearest you shouldn't use 3D charts. Ever. Aside from the fact that they are "aesthetically unappealing" they make reading the data difficult. In a 3D vertical bar chart does the bar terminate at the front/bottom of the top plane, the middle of the top plane, or the back/top of the plane? How are shadows in a line chart helping you to analyze your business? Is a 3D pie chart tilted into perspective easier to understand than a standard pie chart? There are ways to be creative and add some visual fun into your design (backgrounds, slight shadows dividing up the space of an app, a few icons, etc) but 3D charts isn't one of them.
Include a Dashboard page
Under the pressure to develop an app that works many developers focus on creating a variety of ways to analyze the data but forget to have a page that summarizes the data. Include a Dashboard page that gives the summary of the app. If the app is about sales include the major sales figures as well as reference sales goals and whether or not those goals were met. Who were the top five sales people? Who were the lowest five? Give a list of your top selling items as well as your worst selling ones. If it is a medical application give some high level numbers about the number of patients, doctors, hospital staff and if they are up or down from this time last year/quarter/month etc. What is the average wait time to see a doctor? How many procedures have been ordered lately and what are they costing? There are unlimited possibilities of what you could include but the idea is to give your users an overall summary of the status of things before they go into a deep dive and analyze the numbers.
Be Consistent
If you have reoccurring objects that are on many pages keep them in the same location on each page. Use the same colors and font sizes for like minded labels, captions, and text. Design all of your pages to the same width. When things jump around it creates dissonance and users have to adjust and learn how to navigate each page. This process takes time & cognitive effort and is detracting from the time & effort they should be dedicating to using your application. Pick a style and stick to it.
-
QlikView is not vulnerable to Heartbleed OpenSSL issue
Hi QlikView users,We have received some questions from concerned customers asking if QlikView is vulnerable to the Heartbleed OpenSSL security issue.Please note QlikView 11.20 does not use any OpenSSL libraries therefore is not vulnerable to this security threat by itself.QlikView Expressor does use OpenSSL but does not use the version(s) which are vulnerable to Heartbleed.Note: Even though the QlikView product is not affected, customers QlikView... Show MoreHi QlikView users,
We have received some questions from concerned customers asking if QlikView is vulnerable to the Heartbleed OpenSSL security issue.
Please note QlikView 11.20 does not use any OpenSSL libraries therefore is not vulnerable to this security threat by itself.
QlikView Expressor does use OpenSSL but does not use the version(s) which are vulnerable to Heartbleed.
Note: Even though the QlikView product is not affected, customers QlikView environments might be if other parts of their environment are built on platforms like Apache which for example is frequently used as a reverse proxy for SSO.
regards
Global Support
-
Warning - Internet Explorer security vulnerability
Update: Microsoft have issued a security update to address this vulnerability. Please see https://technet.microsoft.com/library/security/ms14-021Hi QlikView users,We don't usually comment on other software products, however internally within Qlik we have informed all users that there is currently a High Severity security vulnerability with Internet Explorer, which affects version 6 through 11.If you use Internet Explorer, we encourage you to in... Show MoreUpdate: Microsoft have issued a security update to address this vulnerability. Please see https://technet.microsoft.com/library/security/ms14-021
Hi QlikView users,
We don't usually comment on other software products, however internally within Qlik we have informed all users that there is currently a High Severity security vulnerability with Internet Explorer, which affects version 6 through 11.
If you use Internet Explorer, we encourage you to investigate this issue and apply security updates, see useful links below.
See Microsoft Technet article
Vulnerability in Internet Explorer Could Allow Remote Code Execution
below:
https://technet.microsoft.com/library/security/2963983
Thank you
Global Support Team
-
Monte Carlo Methods
In some situations in Business Intelligence you need to make simulations, sometimes referred to as "Monte Carlo methods". These are algorithms that use repeated random number sampling to obtain approximate numerical results. In other words – using a random number as input many times, the methods calculate probabilities just like actually playing and logging your results in a real casino situation: hence the name.These methods are used mainly to m... Show MoreIn some situations in Business Intelligence you need to make simulations, sometimes referred to as "Monte Carlo methods". These are algorithms that use repeated random number sampling to obtain approximate numerical results. In other words – using a random number as input many times, the methods calculate probabilities just like actually playing and logging your results in a real casino situation: hence the name.
These methods are used mainly to model phenomena with significant uncertainty in inputs, e.g. the calculation of risks, the prices of stock options, etc.
QlikView is very well suited for Monte Carlo simulations.
The basic idea is to generate data in the QlikView script using the random number generator Rand() in combination with a Load … Autogenerate, which generates a number of records without using an explicit input table.
To describe your simulation model properly, you need to do some programming in the QlikView script. Sometimes a lot. However, this is straightforward if you are used to writing formulae and programming code, e.g. Visual Basic scripts.
The Rand() function creates a uniformly distributed random number in the interval [0,1], which probably isn’t good enough for your needs: You most likely need to generate numbers that are distributed according to some specific probability density function. Luckily, it is in many cases not difficult to convert the result of Rand() to a random number with a different distribution.
The method used for this is called Inverse Transform Sampling: Basically, you take the cumulative probability function of the distribution, invert it, and use the Rand() function as input. See figure below.
The most common probability distributions already exist in QlikView as inverse cumulative functions; Normal T, F and Chi-squared. Additional functions can be created with some math knowledge. The following definitions can be used for the most common distributions:
- Normal distribution: NormInv( Rand(), m, s )
- Log-Normal distribution: Exp( NormInv( Rand(), m, s ))
- Student's T-distribution: TInv( Rand(), d )
- F-distribution: FInv( Rand(), d1, d2 )
- Chi-squared distribution: ChiInv( Rand(), d )
- Exponential distribution: -m * Log( Rand() )
- Cauchy distribution: Tan( Pi() * (Rand()-0.5) )
Finally, an example that shows the principles around Monte Carlo methods: You want to estimate π (pi) using a Monte Carlo method. Then you could generate an arbitrary position x,y where both x and y are between 0 and 1, and calculate the distance to the origin. The script would e.g. be:
Load *,
Sqrt(x*x + y*y) as r;
Load
Rand() as x,
Rand() as y,
RecNo() as ID
Autogenerate 1000;
The ratio between the number of instances that are within one unit of distance from the origin and the total number of instances should be π/4. Hence π can be estimated through 4*Count( If(r<=1, ID)) / Count(ID).
Bottom line: Should you need to make Monte Carlo simulations – don’t hesitate to use QlikView. You will be able to do quite a lot.
See also the Tech Brief on how to generate data.
-
Known issue with Chrome update 34.0.1847.1nn and Bookmarks
Hi QlikView users,We are aware of an issue with the latest Chrome update [34.0.1847.1nn] which causes problems with creating new Bookmarks in the AJAX client. Users will be able to create one bookmark, but if you try again, the create bookmark dialogue will not show. Users of Internet Explorer, Safari and Firefox are not affected.We are working on a fix - please contact support if you experience this issue and we apologize for any inconvenienc... Show MoreHi QlikView users,
We are aware of an issue with the latest Chrome update [34.0.1847.1nn] which causes problems with creating new Bookmarks in the AJAX client. Users will be able to create one bookmark, but if you try again, the create bookmark dialogue will not show. Users of Internet Explorer, Safari and Firefox are not affected.
We are working on a fix - please contact support if you experience this issue and we apologize for any inconvenience.
kind regards
Global Support Team
-
QlikView 11.20 Service Release 6 is now available
Hi QlikView users,We are pleased to confirm that 11.20 SR6, build 11.20 12347, is now available on our download site http://www.qlik.com/download.As well as bug fixes, SR6 introduces the following:3 new client languages, Korean, Traditional Chinese and TurkishImproved Desktop start page and Excel script wizardImproved support for Windows hybrid devicesImproved AJAX repository - faster response times and easier searchSupport for Windows Server 201... Show MoreHi QlikView users,
We are pleased to confirm that 11.20 SR6, build 11.20 12347, is now available on our download site http://www.qlik.com/download.
As well as bug fixes, SR6 introduces the following:
- 3 new client languages, Korean, Traditional Chinese and Turkish
- Improved Desktop start page and Excel script wizard
- Improved support for Windows hybrid devices
- Improved AJAX repository - faster response times and easier search
- Support for Windows Server 2012 R2
- Supportability improvements with new alert email tags
Full details are included in the attached release notes. Thank you for choosing to use QlikView, the world's favorite Business Discovery platform!
Global Support Team
-
It’s Natural to Want to Be Heard! Call for Speakers for the Qlik Conference 2014...
Submit your abstract for consideration todayWe are pleased to announce that the Qlik Conference 2014 will be held from Monday, November 17 through Thursday, November 20, 2014 at the beautiful Shingle Creek Resort in Orlando, Florida. This event will provide a wide range of options that will ensure that all attendees maximize their time and investment. The conference will include keynote speakers, Qlik subject matter expert presentations, a Partn... Show MoreSubmit your abstract for consideration today
We are pleased to announce that the Qlik Conference 2014 will be held from Monday, November 17 through Thursday, November 20, 2014 at the beautiful Shingle Creek Resort in Orlando, Florida. This event will provide a wide range of options that will ensure that all attendees maximize their time and investment. The conference will include keynote speakers, Qlik subject matter expert presentations, a Partner Showcase and multiple opportunities to network and have some fun with old and new friends. It will also feature session tracks that highlight our customers’ experience, expertise and success with QlikView.
Our Call for Speakers is now open and we urge you to engage. Your peers are interested to know what you have discovered and how you are solving business problems with QlikView. We are leaving the topics up to you, but here are some ideas for your consideration:
- Use cases by industry including healthcare, life sciences, financial services, manufacturing, high tech, and retail.
- Details on how you are making business decisions leveraging data and analytics in your company
- Technical talks regarding deployment strategies, growth strategies, and application and development
- How you are creating a culture in your organization of asking questions and making decisions around data
- Industry leading dashboard design
- Communicating with your executives using data stories
- Any talk track that you think your peers will appreciate and learn from
We will be accepting submissions on a rolling basis. For best chance of selection, we encourage you to submit early. The call will close on May 16 and selection decisions will be communicated by May 23. The submission form will allow you to submit your session abstract and screenshots of sample dashboards. Special consideration will be given to those submissions that include real-world examples of QlikView in use.
Customers who are selected to speak at the Qlik Conference 2014 will receive a complimentary conference pass. Only one complimentary pass will be provided per session.
Submit your abstract today for consideration.
Questions?
For all questions on customer speaker submission, please email: Donna.Edwards@qlik.com
