Newbie asking questions, please help me with my baby steps with Qlikview [:)]
I have document which contains multi box where you can select for example first name, last name, age, hobby, hometown and so on. Then I have chart, where I want to show average of ages towards time.
Now, when nothing is selected, calculations is done correctly: like sum of all ages / count of all ages. But if I select for example some hometown, calculation goes wrong: sum of ages in the selected hometown / count of all ages.
I get the correct answer by doing calculation like this: =avg({<Hometown>} Age), but the calculation goes again wrong with everything else than Hometown selection. So, Is there a way to do some selective set analysis? Where calculation condition is depending on what selections have been made in the multi box?
