topic Re: Error in calculated dimension in QlikView

Error in calculated dimension

natallia2406 — Wed, 25 Nov 2020 16:16:04 GMT

Total elasticity is the maximum value.

But I can’t calculate for the total value the amount for the period when the elasticity was maximum.

the amount must be 1001

please help me

Re: Error in calculated dimension

ramasaisaksoft — Tue, 05 Nov 2019 07:07:35 GMT

Hi,

for elasticity why did you used if( Dimensionality()=1, i was unable to understand. once you had given Dimensionality Aggregation how you used Max () function again?

Dimensionality won't work in Total.it is clearly mention in our Help guide also.

please check your requirement once again

For more information on Dimensionality please go through the below link.

https://community.qlik.com/t5/QlikView-Documents/How-to-use-Dimensionality/ta-p/1485559

Correct me, if understand your query wrongly

Re: Error in calculated dimension

natallia2406 — Tue, 05 Nov 2019 07:30:23 GMT

I need to receive not the sum in the total value of the expresston amount

the amount needed for the week when there was a maximum value of elasticity