topic Re: Count not selected data in QlikView

Count not selected data

Tue, 28 Aug 2012 14:27:46 GMT

Hello,

i have adress data.

I filter all with Name “Maier”

Now i want the Information how many People life in Town (count all for Berlin), how many “Maier” life in town (count all for “Maier” in Berlin)

these results I want: (but I do not know the functions)

Udo Maier, Berlin , 3.500.000, 1

Karin Maier, Hamburg, 1.800.000, 2

Otto Maier, Hamburg, 1.800.000, 2

whiteline — Tue, 28 Aug 2012 15:08:04 GMT

If you want to "modify" the selections for a specific expression you can use Set Analysis.

For example. The names are filtered and you want to Count all persons in Berlin.

So you should unselect Name and select Berlin.

With Set Analysis it is =Count({$<Name=, Town={"Berlin"}>} Name)

For more information look for the words "Set Analysis" in a QV help index.

Anonymous — Tue, 28 Aug 2012 17:01:02 GMT

Ths will give you the whole number of people (Names) in Towns where the selected Names reside:

=count({<Name=, Town=P({<Name=P(Name)>})>} Name)

Regards,
Michael