topic Re: dynamic dimension in QlikView

dynamic dimension

Anonymous — Wed, 01 Oct 2014 15:25:55 GMT

Hello at all,

i want create a dynamic dimension:

i have 3 Formulas:

Dynamic Dimension	Formula 1	Formula 2	Formula 3
if([Formula 1] = 0, 'YES, 'NO')	= fabs([Formula 3] - [Formula 2])	= sum(x)	= sum(y)
YES	0	10	10
NO	5	10	5

How can i create such an dynamic dimension? i can't work with a Dynamic Dimension and [Formula 1] Expression

Re: dynamic dimension

vgutkovsky — Wed, 01 Oct 2014 16:35:15 GMT

You need to think about what the real dimension is behind this calculated dimension. Meaning, what do you want to sum(x) and sum(y) over? Let's say it's "Product". Then your calculated dimension would look like this:

aggr(

if(fabs(sum(x)-sum(y))=0,'YES','NO')

,Product

)

Regards,

Vlad

Re: dynamic dimension

MarcoWedel — Wed, 01 Oct 2014 16:59:00 GMT

this looks like some kind of recursive or cyclic definition.

How can a calculated dimension depend on an expression that evaluates based on the dimension?

I don't think this is possible.

regards

Marco