Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

The Avarage Value from a Bar Chart with Limited Dimensions

Hello,

In my QlikView report there is a bar chart where in the expressions tab is noticed a function of sum from 50 variables,

but in dimensions I use a field which consists of limited set of the 16 variables.

By this means, there is a function for the total set of 50 variables but on the chart shold be only 16 of them.

The problem is, that I need to calculate the average value from the bar chart (only for 16 parameters) and show the result in design above, for example in a text object. But using the function AVG from the expression, I have as a result the avarage value for all 50 variables.

Is it possible somehow to solve this problem not in the script redactor?

Thanks a lot in advance for your participation!

0 Replies