Discussion Board for collaboration related to QlikView App Development.
My question is how could I get a value of previously calculated "calculated dimension" to another calculated dimension or expression?
Please look at attached example - I calculate expr1, and I want to use that value in expr2. How to do it?
Ps. Column D could be also an chart expression (ordinary expression, not dimension...)
expression1: Label = age, expression = max(age) (for example)
expression2: Label = age2, expression = [age] * 2 (use label of previous expression)
expression3: Label = age3, expression = [age2] + [age]
Your way works, but only when talking about normal expression - it don't work with Calculated Dimensions...
what columns you put in Calc. dimension?
in you example I don't see any calc dims
Sorry - maybe I was not clear about it..
Column A is a normal dimension, columns B and C are calculated dimensions, and column D is a normal expression...
Can you move columns B and C into expressions? 🙂
Calculated dimensions are not good approach, it works very slow if you have many rows in charts. Expressions more quickly.
Hi, I have a similar issue where I have a calculated dimension where I need to use the value in an expression. Is there a way to use this value in my expression? Please note that my chart does not work when I use the calculated dimension as an expression as it is an aggregated calculation.
Thanks for any help you can provide!
I have the same problem as Kristy someone knows how to fix this?
in case like your, better use expression, like says Anatoly, just try...
I think it's best solution...
the problem with expressions is when i use the code, i use as calculated dimension it will not show 2 thesame records. i have the following:
- NAME: dimension
- Start: calculated dimension
- End: expression
sometimes a name as multiple start dates when i use Start as expression it only will show 1 record