How I get a formual as dimension

[#1]

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

[marcus_sommer]

Have a look here: http://community.qlik.com/blogs/qlikviewdesignblog/2014/04/08/calculated-dimensions

- Marcus

[JonnyPoole · Accepted solution]

You can create a calculated dimension and wrap your expression in an AGGR function.

aggr(  sum(Column I) / sum( Column II) ,  <Dimension> )

[#4]

What does you mean with <Dimension> is this a standarfield or I have to Change the <Dimension> in an other word?

[JonnyPoole]

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...

[#6]

Use calculated Dimension