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

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

boryspower — Tue, 15 Jun 2010 11:20:31 GMT

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

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

sparur — Tue, 15 Jun 2010 12:01:52 GMT

Hello, Boris.

It's simple:

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]

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

boryspower — Tue, 15 Jun 2010 12:34:12 GMT

Hi,

Your way works, but only when talking about normal expression - it don't work with Calculated Dimensions...

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

sparur — Tue, 15 Jun 2010 12:36:36 GMT

what columns you put in Calc. dimension?

in you example I don't see any calc dims

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

boryspower — Tue, 15 Jun 2010 12:47:59 GMT

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

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

sparur — Tue, 15 Jun 2010 12:51:27 GMT

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.

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

Mon, 11 Oct 2010 21:38:08 GMT

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!

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

Wed, 12 Jan 2011 16:20:54 GMT

Hi,

I have the same problem as Kristy someone knows how to fix this?

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

Wed, 12 Jan 2011 16:59:59 GMT

in case like your, better use expression, like says Anatoly, just try...

I think it's best solution...

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

Thu, 13 Jan 2011 08:58:37 GMT

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

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

Wed, 02 Mar 2011 08:20:05 GMT

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?

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

Fri, 04 Mar 2011 07:49:20 GMT

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,

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

Fri, 04 Mar 2011 07:55:32 GMT

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 🙂