How to get chart calculated dimension value into another expression/dimension?

[boryspower]

Hello,

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

[#2]

I do have the same problem here (using a calculated dimension into an expression).

I do want to build a "100% stacked bar chart". To do so, I found this help:

http://community.qlik.com/forums/p/39703/156440.aspx

Count ([Student Count]) / Count (TOTAL <[Entry College Code of Student]> [Student Count])

But let's say [Entry College Code of Student] is calculated dimension; how should I write my expression?

[#3]

Another example of my limitation,

In a bar chart, I build a calculated dimension, so I can group values under new category; and the I want to diplay the label of each category on the bar itself.

At that time, I follow instruction from http://blog.qvapps.com/2010/09/10/qlikview-tutorial-vertical-labels-inside-bars/

But the expression DUAL, need to make reference to the calculated dimension. How can I do that?

Thanks,

[#4]

Hello Anatoly ,

Use the following script in you chart.

Expr 1 : Age * 2

Expr 2 : Column (1) + Age

Expr 3 : Age

Please let me know if it again some problem is there 🙂