topic Re: How I get a formual as dimension in QlikView

How I get a formual as dimension

Tue, 19 Aug 2014 15:04:04 GMT

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

Re: How I get a formual as dimension

marcus_sommer — Tue, 19 Aug 2014 15:11:41 GMT

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

- Marcus

Re: How I get a formual as dimension

JonnyPoole — Tue, 19 Aug 2014 15:13:54 GMT

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

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

Re: How I get a formual as dimension

Tue, 19 Aug 2014 15:39:13 GMT

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

Re: How I get a formual as dimension

JonnyPoole — Tue, 19 Aug 2014 15:47:03 GMT

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

Re: How I get a formual as dimension

Tue, 19 Aug 2014 15:53:54 GMT

Use calculated Dimension