topic Re: Calculate dimension problem in QlikView

Calculate dimension problem

kkarlste — Sun, 18 Mar 2018 09:01:03 GMT

I don't know what is this calculate dimension problem?=sum({$<FunctionalAreaLevel={'Turnover'}>}[TURNOVER Sales of the period])

adityaakshaya — Sun, 18 Mar 2018 09:58:36 GMT

Hi Kalle,

I will suggest you to use this in expression rather putting it into dimension to get the value. There is no problem with the expression.

kkarlste — Sun, 18 Mar 2018 10:04:07 GMT

I want this to be the dimension of the calculation not expression.

Excpression is same =sum({$<FunctionalAreaLevel={'Turnover'}>}[TURNOVER Sales of the period]) .

Is this problem?

adityaakshaya — Sun, 18 Mar 2018 10:11:20 GMT

You cannot use Sum in a dimension field until you use aggr function

kkarlste — Sun, 18 Mar 2018 11:07:58 GMT

How should this formula go dimensions?=sum({$<FunctionalAreaLevel={'Turnover'}>}[TURNOVER Sales of the period])