To explain the gauge results one at a time Take for example these four different gauges, all snapped under the context of having “South” selected, and with different Set Analysis statement (or lack of) on both sides of the equation: Generally though I think the Star Equals is the better approach.Ī similar approach can be applied on both sides of a comparison expression. This is far more intuitive for users – as you instil in them that selections affect all objects, but Set Analysis without *= then breaks this.įor prior period comparison it may be that you want to ignore the users selection, so if they select only 2016 you still want to show 2015 as the comparative period. With Equals the users selection is totally ignored, but with Star Equals it is respected. Look what happens though when we select a single Region: You will note that Equals and Star Equals give identical results above. Take this example, shown with no selection made: Another operator that can be used is Star Equals, this gives the intersection of what is specified in the Set and the users selection. Generally I see this implemented in people’s code with an Equals operator, as in the example above. Enter Star EqualsĪ common use case for Set Analysis is to tie a chart or an expression to a specific dimension value. Caution should be taken though not to confuse users. This change should always be clearly signposted to users with labels and legends.įor things like prior period comparison, Set Analysis is brilliant. Set Analysis expressions, however, modify those selections. When Qlik products are explained to them, they are told that their selections effect everything. One of the problems with Set Analysis is that the results can be counter Intuitive to users. They are all however just expansions on the very simple concept of applying selections on a field. So sum(Value) becomes sum(Value), if you only want to add up the values which are flagged as being Relevant in the data.īy nesting Set Analysis syntax, and using different operators, highly complex expressions can be built. You can add a Set to an expression which changes the selection context for that expression – effectively forcing selections that only apply to that one expression. Set Analysis is a subset of expression syntax that can cause some developers issues. From SQL statements, load script, expressions and VB macro code. Qlik developers have a lot of syntax to learn. Set Analysis is a powerful set of syntax which is widely used in QlikView and Qlik Sense applications, but I find that many developers are unaware one of the most useful functions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |