I have a simple table with person's ID and hobby, but one person can have many hobbies, so may have many rows. I want to filter on hobby and show bar chart of all hobbies of people, who have filtered hobbies, for instance:
"Show me hobbies of people who like sports".
But when I create the filter or shows me only sports (as expected). How do I achieve it? It would be a simple sub-query in SQL.
I know I can load the table twice and do the join in ID, but it's not efficient due to table size.
Thank you for the reply. You are almost right about the problem - I want to see almost ALL hobbies of people for the selected Hobby. However I do not see how Stefan Wuhl's answer can be applied here, I'm just a qlik beginner....
I have only one table like this:
lets say I want to see all hobbies of people who's hobby is sports- than should filter people of ID 1 and 2.