topic Re: Set Analysis Expression Issue in QlikView

Set Analysis Expression Issue

Thu, 27 Feb 2014 09:44:18 GMT

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

Re: Set Analysis Expression Issue

MK_QSL — Thu, 27 Feb 2014 09:56:09 GMT

Try Aggr(Your second expression , PERSON_ADDM2_KEY)

Re: Set Analysis Expression Issue

Thu, 27 Feb 2014 10:04:49 GMT

its not wrkn

can u send me the expression please

Re: Set Analysis Expression Issue

er_mohit — Thu, 27 Feb 2014 10:24:11 GMT

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

>}distinct PERSON_ADDM2_KEY)

Re: Set Analysis Expression Issue

Thu, 27 Feb 2014 10:30:55 GMT

can u send the full expression please

i m nt gettng it correctly

Re: Set Analysis Expression Issue

er_mohit — Thu, 27 Feb 2014 10:45:49 GMT

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}

Re: Set Analysis Expression Issue

Thu, 27 Feb 2014 11:01:06 GMT

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

Re: Set Analysis Expression Issue

er_mohit — Thu, 27 Feb 2014 11:03:02 GMT

Send me your application

Re: Set Analysis Expression Issue

kaushiknsolanki — Fri, 28 Feb 2014 09:29:24 GMT

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

Re: Set Analysis Expression Issue

Tue, 04 Mar 2014 13:35:10 GMT

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 }

Re: Set Analysis Expression Issue

kaushiknsolanki — Thu, 06 Mar 2014 13:30:57 GMT

Hi,

In your application Login_Timestamp has only data till 2012 and you are cheking for 2014.

Kindly check on this.

Regards,

Kaushik Solanki