Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
natallia2406
Contributor
Contributor

Error in calculated dimension

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

1 Solution

Accepted Solutions
natallia2406
Contributor
Contributor
Author

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

View solution in original post

2 Replies
ramasaisaksoft

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

 
 

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

natallia2406
Contributor
Contributor
Author

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