Show related data via set analysis

[#1]

Hi Guys.

I have a following problem:

we have table questionnaires which contain Quest_Number, MagazineId, cnt

dict_magasines MagasineId, MagasineName

example

MagasineId, MagasineName

1 PlayBoy

2 Dogs And Cats

3 Time

4 SQL Server Magazine

In every questionary we have several answers on question which magazines do you read

for example

Quest_Number, MagazineId, cnt

1 1 1

1 2 1

1 3 1

4 3 1

4 1 1

I want create chart which show related to Quest_Number Magazines except selected one.

I select Playboy (MagazineId = 1) and Graph show me Dogs And Cats and Time (MagazineId = 2,3)

All what I can imagine about formula is here

=SUM({< MagasineName={"*"} - P({$}), Quest_Number=P({$})>} cnt)

I need get Quest_Number related to selected MagasineName and show all Magazines related to Quest_Number

Thanks.

[#2]

Here is Qlikview file http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.03.44.80/Au...

[#3]

I find correct formula . here is new one

=SUM({ $< MagasineName= ,Quest_Number=P({$})> - $ } cnt)

In my application exist link table which have sections related to several facts .. and

my formula is

=SUM({ $< Press= ,Quest_Number=P({$<Type={'PRPRMIX'}>})> - $ } Press_prompt_cnt)

Type field identify fact. This help you select only questionaries related to specific fact.

Hope this solution can help somebody.