Set Analysis Expression Issue

[#1]

Hi,

I am calculating two expressions:

1)No.of unique Site visits People who have visited the site.

2)No.of Unique return site visits: People who have visited the site twice.{Count >1 basically}

First expression:{No.of unique Site visits}

Second expression:{No.of Unique return site visits}

But i am not getting the correct results for the second one

Any issue with the expression?

Please help

Message was edited by: Poornima Narayanan

Message was edited by: Poornima Narayanan

[MK_QSL]

Try Aggr(Your second expression , PERSON_ADDM2_KEY)

[#3]

its not wrkn

can u send me the expression please

[er_mohit]

count({<PERSON_ADDM2_KEY=P({<PERSON_ADDM2_KEY= your 1st expression }>}PERSON_ADDM2_KEY)>1

>}distinct  PERSON_ADDM2_KEY)

[#5]

can u send the full expression please

i m nt gettng it correctly

[er_mohit]

simply write your 1st expression and last write >1

it means

No.of Unique return site visits: People who have visited the site twice.{Count >1 basically}

[#7]

i am getting the logic.But nt able to form the expression .Its throwing error.

[er_mohit]

Send me your application

[kaushiknsolanki]

Hi Poornima,

     I have checked your QVW file and as per my understanding the calculation is showing correct result.

     Kindly let me know what result you are expecting.

Regards,

Kaushik Solanki

[#10]

Hi Kaushik,

If you see the below query : Persons : 68,74,191 have only record with PG_NM as Home.

But in my application (I have attached the same),

No.of unique Site visits:5

No.of Unique return site visits:5  {Which is wrong and shud be 2 .Only 217 and 660 have counts greater than 1 }