topic Re: Sum intersection of item with differents values in QlikView

Sum intersection of item with differents values

Mon, 17 Jun 2013 10:15:05 GMT

hello,

i explain you my problem...

I ve an table with an flag on an counter Of Item and site is an dimensio of the table (Fact_item)

i would like to calculate the intersection of the Item which are with connect to the 00P and the site OOM ....

I don't how to do in set analysis

this formular is the union but i don t know how to do the intersection

sum

({$<[Nb Créa Item]={1},Site={'00P00','00M00'}>} Nb Créa Item

)

do you have any idea?

thanks

Mon, 17 Jun 2013 10:20:14 GMT

in set analysis + sign use for union, and * sign use for intersection.

try this(UPDATED)

sum({$<[Nb Créa Item]={1},Site={'00P00'} * {'00M00'}>} Nb Créa Item)

Mon, 17 Jun 2013 11:12:56 GMT

thank but it doesn't work it gives me 0 and i ve checked for a lot of item i ve the both site :

For one item ,

sum({$<[Nb Créa Item]={1},Site={'00P00'}>} Nb Créa Item) =1

sum({$<[Nb Créa Item]={1},Site={'00M00'}>} Nb Créa Item)=1

so the intersection should be more than 0

.....

Mon, 17 Jun 2013 11:41:28 GMT

I ve tried this formalar and it s working inside an text object but when i try to put in an chart it doesn't work ....

Do you have any idea of the origin of this problem....

sum({$<[Nb Créa Item]={1},Site={'00P00'}>*<[Nb Créa Item]={1},Site={'00M00'}>} [Nb Créa Item]

)

cause the dimension are corrects.... cause my result is working with the selection but not in chart...

Mon, 17 Jun 2013 12:13:50 GMT

Sorry i ve made an bad manipulation ...

My problem is only when i tried to display on an chart and i try to display ...there is nothing all the result is on other ...

And i ve checked with list of selection, it s working i ve result with the dimension ...

it s an problem with the object graph i don t know why...

Mon, 17 Jun 2013 15:07:58 GMT

nobody has an idea what is the origin of my problem ?