Set analysis and selections

Mon, 07 Jun 2010 14:49:59 GMT

Hi,

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?

Thanks for your help,

Outi

topic Set analysis and selections in QlikView

Set analysis and selections