topic Re: Intersection in Set analysis in QlikView

Intersection in Set analysis

Fri, 19 Oct 2012 19:48:15 GMT

Hi Guys

I want to have the intersection values of two set expression in a straight table.

For example in the database i have CustId and Flag ( Flag values are 'Y' and 'N')

In a straight table i need CustId which are common in both the flags.

i.e. intersection of Count({<Flag = {'Y'}>}CustId) and Count({<Flag = {'Y'}>}CustId)....

Please help......................

Re: Intersection in Set analysis

MayilVahanan — Fri, 19 Oct 2012 19:51:09 GMT

I think you want like this

=Count({<Flag = {'Y'}>*<Flag={'N'}>}CustId)

Hope it helps

Re: Intersection in Set analysis

Fri, 19 Oct 2012 19:59:21 GMT

hi Mayil

Thanks for the reply but i also used the same expression but i am not getting the result ...

can you please send me a demo application .... it will be a great help.....

Re: Intersection in Set analysis

MayilVahanan — Fri, 19 Oct 2012 20:13:25 GMT

Sorry, That not works

=Count({<CustID = {"=Count(Distinct Flag)=2"}>}CustID)

Hope it helps

Re: Intersection in Set analysis

Fri, 19 Oct 2012 20:35:20 GMT

Hi Mayil

thanks a lot .. it worked .......but i have a 2 questions for you

First >>>> Why =Count({<Flag = {'Y'}>*<Flag={'N'}>}CustId) did not worked??? because

=Count({<Flag = {'Y'}>+<Flag={'N'}>}CustId) and =Count({<Flag = {'Y'}>-<Flag={'N'}>}CustId) are working fine....................

Second>>>>>>>>>>>>>Suppose i have following Expressions

Count( {<Status = {'Pending'},ItemType = {'A'}>} ID)

and

Count( {<Status = {'Ready'},ItemType = {'B'}>} ID)

now how can i get the common Count of ID............i.e. Intersection between 2 expressions

Thanks in advance.......

Re: Intersection in Set analysis

MayilVahanan — Fri, 19 Oct 2012 20:54:48 GMT

If custId and Flag are in different table, then '*' works, if both fields are in same table, then it not works. please check attached file..

Table1:

CustID,Flag

1,Y

1,N

2,Y

In this,

=Count({<Flag = {'Y'}>*<Flag={'N'}>}CustID)

It check the row wise, so for a custID , no possibility for have both Y and N in same row.. so its result zero..

I think you understand what am saying..

Re: Intersection in Set analysis

Fri, 19 Oct 2012 21:00:17 GMT

thanks a lot for clearing my concepts......

Can you please also tell me about my second question ... how to do that ????

Re: Intersection in Set analysis

MayilVahanan — Fri, 19 Oct 2012 21:11:51 GMT

I think, its correct method or not, but its help u