topic Re: Intersection in two alternate states in QlikView

Intersection in two alternate states

jasonseril — Tue, 29 Oct 2013 04:00:31 GMT

Hello all,

I have a simple inline data:

test:

LOAD * INLINE [

PLACE, VALUE

A, 4

A, 5

A, 6

A, 7

A, 8

B, 1

B, 2

B, 3

B, 4

B, 5

B, 9

];

then I created two alternate states ([Group 1] and [Group 2]. I want to count the number of "intersection(s)' in dimension PLACE between the two alternate states. In the data (A and B), they have two the same values (4 and 5). I tried some script (below) from a comment from another thread

=Count({[Group 1]<PLACE*=p({$}PLACE::PLACE)> * [Group 2]<PLACE*=p({$}PLACE::PLACE)>} VALUE)

but it only displayed 0, not 2. I have attached the image below:

Please check if I missed something or the code is wrong.

Thanks in advance and best regards,

Jason

Re: Intersection in two alternate states

Tue, 29 Oct 2013 04:43:00 GMT

Hi Jason,

Can you attach your testing appication? That will be more understandable.

Thanks!!

Regards,

Yojas

Re: Re: Intersection in two alternate states

jasonseril — Tue, 29 Oct 2013 05:17:23 GMT

Hello Yojas,

thank you for a fast reply, please find attached the qvw for your checking.

best,

Jason

Re: Intersection in two alternate states

Tue, 29 Oct 2013 06:00:48 GMT

PFA hope it will help you

Re: Intersection in two alternate states

jasonseril — Tue, 29 Oct 2013 06:11:07 GMT

Hello Nirmal,

Thanks for the qvw file.

However, there are only two data from A and B that are the same (4 & 5), how come your script yielded 11?

best,

Re: Intersection in two alternate states

Tue, 29 Oct 2013 06:20:52 GMT

Sorry Jason after that i saw the exact requirement

Re: Re: Re: Intersection in two alternate states

Tue, 29 Oct 2013 10:24:24 GMT

Hi Jason,

PFA for your requirement.

I hope it hte same which you were expecting!!!

Regards,

Yojas

Re: Intersection in two alternate states

tresB — Tue, 29 Oct 2013 10:24:29 GMT

Hello Jason,

PFA.

Use expression: =Count({[Group 1]<VALUE=P({<PLACE=[Group 2]::PLACE>})>}VALUE)

Re: Re: Re: Intersection in two alternate states

Tue, 29 Oct 2013 11:07:25 GMT

Hi Jason,

Please update us if you got your solution by marking it correct !!!

Thanks!!

Regards,

Yojas

Re: Intersection in two alternate states

jasonseril — Wed, 30 Oct 2013 08:19:51 GMT

Hi tresesco,

it's correct, thank you very much.

best regards,

jason

Re: Intersection in two alternate states

jasonseril — Wed, 30 Oct 2013 08:23:50 GMT

Hello Yojas Samarth

Please check tresesco attached qlikview and script, it worked.

Thank you.

best regards,

jason