Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count not selected data

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

2 Replies
whiteline
Master II
Master II

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
Not applicable
Author

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