Have you ever wondered how the examples from the Qlikview help may look like?
Please see below and enjoy responsibly...
If expression or field iterated over the chart dimension(s) contain one single value, that value is returned, else NULL is returned. Only can return numeric values as well as text values.
What does it mean:
When in dimension(column) all values are
the same ,Only will return this value:
Please load below script and look at our examples:
load * inline
After reload our TableBox looks like this:
Now we can create Straight table and used Salesmen as dimension:
1) only(Sales) returns 10 as this is the only single value in this column
2) only(Price*Quantity ) will not return any values for Robert as the the values returned are 60 (2*30) and 30(1*30).
( We will come back to our Salesman later)
Now let's add another dimension - Price
This time expression will return values for Robert as it will see the combination of dimensions
as one (single) values.
(If you still in doubt go to our script and change the Price for Robert in second row to 3)
Let's go back to our example number 3 - only(TOTAL Salesman)
(The Example below is based on help from Henric Cronstrom
as I could not get my head around this expression and where can be used)
When you look at the expression you may wonder why we have TOTAL here.
In most cases you will uses this prefix to get numerical total like:
But TOTAL can also return string value.
If we choose one value from Salesman dimension
only(TOTAL Salesman) will return this value.
As an aggregation function, only() can be used with set analysis
is used return Quantity for Salesman where Price is equal to 2.
Still feeling hungry?