Set Analysis Help

[#1]

Hi,

I'm relatively new to qlikview and I need to use set analysis to gather data from a table.

Currently I'm working on a piece of code that will return information from the previous subset to my selection.

For example,
Groups contain accountID and from these accountID I can get expenditure.
Say Group 1 has 5 accounts and I want to select an account, the information will return the data for the group as a whole rather than the accountID seelection. So I would be looking at expenditure for the group rather than the seperate selected account.

Can you please help as I am really stuck on this one?

Thanks in advance

[#2]

Hi mckay,

Could you elaborate your requirement clearly with some example?

Regards,

Raj Kishor

[#3]

http://community.qlik.com/media/p/82595.aspx

[#4]

for an example,

I have created a variable for working out expenditure -vExpend,

the fields im using are AccountID and Group
The design of the table is: Group>AccountID

=

sum( {$<~AccountID>}(vExpend))

I thought that this code would ignore the selection in AccountID and look at the expenditure for Group.

[gandalfgray]

If you want to ignore the selection in AccountID do like this:

Sum({$<AccountID={*}>} vExpend)

[#6]

If you want to ignore the selection in AccountID do like this:

Or

Sum({$<AccountID=>} vExpend)