topic Re: Help Needed in QlikView

Help Needed

Wed, 15 May 2013 09:28:50 GMT

i have two columns one is ID and second is Date. My requirement is that i have to find out Row Num for each record and that i have done by RowNo() fuction but tha problem is that and the main requirement is that if the Id is changed then RowNo() again starts from 1,2,......

Help Needed Sample Data File is attached

Plz Its Urgent

Re: Help Needed

tresB — Wed, 15 May 2013 09:47:53 GMT

See the attached application.

Thanks.

Re: Help Needed

Wed, 15 May 2013 09:58:28 GMT

Tressco could u plz explain me what this line of code do:

If(ID=peek('ID'),Peek('Count')+1,1) as Count

Re: Help Needed

Wed, 15 May 2013 10:03:06 GMT

Tressco could u plz explain me what this line of code do:

If(ID=peek('ID'),Peek('Count')+1,1) as Count

Thanks In Advanced

Re: Help Needed

tresB — Wed, 15 May 2013 10:05:21 GMT

ID=peek('ID') - checks if the current ID is same as the previous one loaded, if so the counter is incremented(peek('count')+1). If not so, that means the ID is a new one so the counter gets initiated as 1.

Note: assumption: your data is sorted on ID field.

Hope this helps.

Thanks.

Re: Help Needed

kumarnatarajan — Wed, 15 May 2013 10:07:21 GMT

Hi,

Find the attached File

Re: Help Needed

tresB — Wed, 15 May 2013 10:16:31 GMT

Hello Kumar,

I think it is not a good idea to use autonumber for this purpose. Because that does not guarantee of sequencial number generation for large data set.

Thanks.

Re: Help Needed

Wed, 15 May 2013 10:22:08 GMT

Tressco Its Not work when i fetch the dat from excel

Thanks

Re: Help Needed

kumarnatarajan — Wed, 15 May 2013 10:23:36 GMT

Hi tresesco,

Ok! Thanks for advice. Please Check now . i am currected that issue using with RowNo().

See the below script. This good one:

Taple1:

LOAD *,RowNo() as TempRowNo INLINE [
    ID , Date
    A1, 5/12/13 12:00 AM
    A1, 5/13/13 12:00 AM
    A1, 5/14/13 12:00 AM
    A1, 5/15/13 12:00 AM
    B2, 5/16/13 12:00 AM
    B2, 5/17/13 12:00 AM
    C4, 5/18/13 12:00 AM
    C4, 5/19/13 12:00 AM
    C4, 5/20/13 12:00 AM
    D5, 5/21/13 12:00 AM
    E6, 5/22/13 12:00 AM

];

New_one:
NoConcatenate LOAD     ID,
        Date,
        AutoNumber(Date&TempRowNo,ID) as RowNo
Resident Taple1 order by ID, Date;

DROP Table Taple1;

Re: Help Needed

tresB — Wed, 15 May 2013 10:27:53 GMT

Your application data and source data do not match. Else the output seems fine. right?

Re: Help Needed

Wed, 15 May 2013 10:51:29 GMT

kumar plz attached the latest version that u have change

Re: Help Needed

kumarnatarajan — Wed, 15 May 2013 10:55:25 GMT

Hi,

Find the attached file. This is latest version