topic Funtion Optimization in QlikView

Funtion Optimization

Mon, 23 Apr 2012 08:27:31 GMT

hello everyone,

i have function optimization problem, i want to count the distinct "%SessionID" with the help of my script.

i used this .....AutoNumber(RecNo(), %SessionId) as NewID ..// this is working perfectly ok...like its returning me the NewID field with values 1,2,3,4... but this autonumber function is slow i want to use some thing like this

if (peek( '%SessionID')= %SessionID , (%SessionID+1),1)....// its not working its returning me 1,1,1,1,1...in all fields with same %SessionID. but i need the outcome like 1,2,3,4....

Any help on this?

Regards,

Salman

Re: Funtion Optimization

d_pranskus — Mon, 23 Apr 2012 08:37:56 GMT

Try this

if (peek( '%SessionID')= %SessionID , (peek('%SessionID')+1),1)

Darius

Funtion Optimization

CELAMBARASAN — Mon, 23 Apr 2012 08:41:06 GMT

Hi,

Try with previous() or peek() like this

if (Previous( [%SessionID]) = [%SessionID] , (NewID+1),1) as NewID

if (peek( '%SessionID')= [%SessionID] , (NewID+1),1) as NewID

Celambarasan

Funtion Optimization

Mon, 23 Apr 2012 08:42:09 GMT

thanks Darius, i have tried this but returning the same values in the column..1,1,1,1,1...

Funtion Optimization

Mon, 23 Apr 2012 08:51:09 GMT

thanks Celambarasan, but getting the same result 1,1,1,1,1...

I have to use Autonumber for numbering like 1,2,3,4 .... for the same %SessionID ?

regards,

salman

Re: Funtion Optimization

d_pranskus — Mon, 23 Apr 2012 08:58:33 GMT

Try this example

LOAD * INLINE [

%session

];

t1:

LOAD

%session,

IF(PEEK('%session') = %session, PEEK('newid') + 1, 1) AS newid

RESIDENT t;

DROP TABLE t;

And you must have your source table sorted by %session.

Darius

Funtion Optimization

Mon, 23 Apr 2012 09:02:25 GMT

Perfect Darius,Thanks:)