topic Re: Set analysis: Ignore or include selected dimension in QlikView

Set analysis: Ignore or include selected dimension

Wed, 15 May 2013 08:50:54 GMT

Hi,

I am not able to find out how to ignore and include some of the dimensions using set analysis. For ex:

Emp Team Sales

e1 T1 1000

e3 T2 500

e2 T1 1500

Now selecting e1 should give sum of corresponding team i,e 1000 + 1500 = 2500.

I am using this expression in Text object:

sum({$< Team = {$(#vTeam)}>}Sales) but result is 0.

What is the error here?

Also, what are other ways to achieve this?

Thanks for your time!

regards,

Mayank

Message was edited by: mayank.rishu

Re: Set analysis: Ignore or include selected dimension

Wed, 15 May 2013 10:45:57 GMT

this should work

sum({$<[team]={'t1'}>} [sales])

Re: Set analysis: Ignore or include selected dimension

Gysbert_Wassenaar — Wed, 15 May 2013 10:49:30 GMT

If you have a variable vTeam with value T1 then sum({$< Team = {'$(vTeam)'}>}Sales) will return 2500.

It's not possible to select only e1 and get the total for T1 back and not for T2. e1 is a member of both T1 and T2 so there's not enough information to determine which team total should be shown if you select only e1.

Re: Set analysis: Ignore or include selected dimension

Wed, 15 May 2013 10:50:36 GMT

Thanks miteamgib!

This will certainly work but I can't limit it to 't1'. Data can vary accordingly.

Re: Set analysis: Ignore or include selected dimension

Wed, 15 May 2013 10:53:52 GMT

Hey Gysbert,

yes I have variable but this is also showing up 0!

Re: Set analysis: Ignore or include selected dimension

Wed, 15 May 2013 11:50:05 GMT

Gysbert,

I agree on your explanation so lets invert the selection to e2. Selecting e2, I need total sum of T1.

Mayank

Re: Set analysis: Ignore or include selected dimension

Gysbert_Wassenaar — Wed, 15 May 2013 16:40:34 GMT

Try sum({<Emp=p({<Emp=,Team=p(Team)>}Emp)>}Sales). See attached example.

Re: Set analysis: Ignore or include selected dimension

Thu, 16 May 2013 09:19:56 GMT

This looks correct! Exactly what I was looking for. Thank you!

Re: Set analysis: Ignore or include selected dimension

MK_QSL — Thu, 16 May 2013 12:41:51 GMT

Can you explain ? Thanks in advance.

sum({<Emp=p({<Emp=,Team=p(Team)>}Emp)>}Sales)

Re: Set analysis: Ignore or include selected dimension

Wed, 16 Dec 2015 18:35:19 GMT

I had the same question

p = possible

e = exclude

See:

P() & E() and where do you use them?