Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello together,
does anyone know, how I get formulas as Dimension.
here you see the example:
Colum I | Column II | Column I / Column 2 | Column I + Column II |
---|---|---|---|
122 | 2 | 61 | 124 |
124 | 2 | 62 | 126 |
126 | 2 | 63 | 128 |
Thanks
You can create a calculated dimension and wrap your expression in an AGGR function.
aggr( sum(Column I) / sum( Column II) , <Dimension> )
Have a look here: http://community.qlik.com/blogs/qlikviewdesignblog/2014/04/08/calculated-dimensions
- Marcus
You can create a calculated dimension and wrap your expression in an AGGR function.
aggr( sum(Column I) / sum( Column II) , <Dimension> )
What does you mean with <Dimension> is this a standarfield or I have to Change the <Dimension> in an other word?
Its a generic placeholder for the dimensional values you are aggregating over
In your example it would probably look like something like this:
=aggr( sum([Column I])/sum([Column II]), [Column I],[Column II])
In practice, this isn't a great example because if column1 and column2 are being used as dimensional values , the straight table will only show unique combinations of I and II. So if you had a duplicate record it would show as 1 record, but the calculation would take into account both as it aggregates both.
I would suggest using non-numeric dimensional values for this technique like Region or Year etc...
Use calculated Dimension