topic Set Analysis Help in QlikView

Set Analysis Help

Mon, 06 Sep 2010 13:29:04 GMT

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

Set Analysis Help

Mon, 06 Sep 2010 13:35:07 GMT

Hi mckay,

Could you elaborate your requirement clearly with some example?

Regards,

Raj Kishor

Set Analysis Help

Mon, 06 Sep 2010 13:39:04 GMT

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

Set Analysis Help

Mon, 06 Sep 2010 13:56:06 GMT

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.

SV:Re: Set Analysis Help

gandalfgray — Mon, 06 Sep 2010 15:54:10 GMT

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

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

SV:Re: Set Analysis Help

Tue, 07 Sep 2010 09:47:19 GMT

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

Sum({$<AccountID=>} vExpend)