Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Refer to a calculated dimension in another calculated dimension

Is there a way to refer to a calculated dimension in another calculated dimension in a pivot table ?

I created a dimension named Account. In another calculated dimension, I would like to have an expression using Account. Is it possible to refer to Account with its label ? It seems to me that it is not... Should I reproduce all the time the whole expression for the calculated dimension 'Account' ?

Thanks in advance

3 Replies
Highlighted
sudeepkm
Valued Contributor III

Re: Refer to a calculated dimension in another calculated dimension

I do not think the Calculated Dimension expressions in a chart can be used or referred just like the Expression in a chart. Expressions in a chart can be reused just using the Label. If I find anything about it I'll inform you.

Highlighted
Not applicable

Re: Refer to a calculated dimension in another calculated dimension

Using the label returns a integer value, whereas using the whole expression for the calculated dimension, this is working, but the performance is not satisfactory

Highlighted
MVP & Luminary
MVP & Luminary

Re: Refer to a calculated dimension in another calculated dimension

Hi,

By using Column() in expression you can get dimension values, but for Calculated Dimension this won't works.

Regards,

Jagan.