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!