topic Re: Set Analysis with exactly all P() values in QlikView

Set Analysis with exactly all P() values

Tue, 17 Mar 2015 16:55:44 GMT

Hi, I have the following table:

SEMENTE	AREA	SACAS/HÁ
SEM 1	1	50
SEM 1	2	60
SEM 1	3	65
SEM 1	4	61
SEM 1	5	58
SEM 1	6	66
SEM 1	7	70
SEM 1	8	56
SEM 1	9	79
SEM 1	10	65
SEM 2	3	50
SEM 2	6	66
SEM 2	7	74
SEM 2	8	50
SEM 2	10	63
SEM 3	1	68
SEM 3	2	66
SEM 3	3	65
SEM 3	4	64
SEM 3	5	75
SEM 3	6	59
SEM 3	7	51
SEM 3	8	53
SEM 3	9	59
SEM 3	10	55
SEM 4	3	56
SEM 4	4	66
SEM 4	5	67
SEM 4	6	61
SEM 4	7	63
SEM 4	8	68
SEM 4	9	66
SEM 4	10	65
SEM 5	1	64
SEM 5	3	75
SEM 5	6	63
SEM 5	8	59
SEM 5	9	55

and I have to show the "SEMENTES" where I have exactly all possible values from "AREA" when I select one of this "SEMENTES"

Ex: When I select the "SEM 2" I have to show the "SEM 1", "SEM 2", "SEM 3" and "SEM 4".

now i'm using the following set analysis:

Avg({<AREA=P(AREACOMP)>} [SACAS/HÁ])

but it's returning the "SEM 5" too.

Someone have an idea to solve my problem?

Re: Set Analysis with exactly all P() values

Tue, 17 Mar 2015 17:11:44 GMT

Hi Chintia

area 3,6,8 are in Sem 2 and Sem 5, so is it not right that sem 5 is in there?

Just to clarify, when you select sem 2, the possible area is 3,6,7,8,10 and you want your calculation to work on all of those areas, regardless of semetes right? That looks to be happening, so I'm not sure what the issue is

Joe

Re: Set Analysis with exactly all P() values

sunny_talwar — Tue, 17 Mar 2015 17:19:09 GMT

I think what he wants is since Sem 2 has 3, 6, 7, 8, 10 then only those Sem's which have all these area's should be shown. Sem 5 only has 3, 6, 8 and don't have 7 & 10 so it should be shown. That's what I interpreted from him post.

Best,

Re: Set Analysis with exactly all P() values

Tue, 17 Mar 2015 17:19:11 GMT

relating tables

Re: Set Analysis with exactly all P() values

Anonymous — Tue, 17 Mar 2015 17:49:44 GMT

Tis expressions works, if I got the request right:

Avg({<AREA=P(AREACOMP),
SEMENTE={"=count(distinct AREACOMP)=count({<AREA=P(AREACOMP)>} total<SEMENTE> AREA)"}>} [SACAS/HÁ])

Re: Set Analysis with exactly all P() values

Tue, 17 Mar 2015 18:27:49 GMT

Correct friend sunindia

Re: Set Analysis with exactly all P() values

Wed, 18 Mar 2015 14:33:37 GMT

worked!! Thank you Michel!!