topic Re: Re: Generate no based on Lot no. in QlikView

Generate no based on Lot no.

rohit214 — Wed, 09 Oct 2013 08:37:49 GMT

Hi All,

I want to generate the no against the lot no. since i have a common commision no. but in a commision no there are n no of lots so i want to generate no agaist lot no.

ex.

Commision no	Lot no.	reuired output
201282591201	10	1
201282591201	11	2
201282591201	12	3
201282591201	13	4
201282591201	14	5
201282591201	15	6
201282591201	16	7
201282591201	17	8

so every commision wise there are n no of lot no so i awnt those no based on lot no.

please find the attached sample data.

looking for help

Regards

Rohit

Re: Generate no based on Lot no.

rohit214 — Wed, 09 Oct 2013 08:46:02 GMT

any one please help...

Re: Generate no based on Lot no.

saumyashah90 — Wed, 09 Oct 2013 08:50:02 GMT

Use RowNo() while loading

Re: Generate no based on Lot no.

tresB — Wed, 09 Oct 2013 08:53:26 GMT

Try something like this:

Load [Commission No],

[Lot No],

If( [Commission No]=Peek('[Commision No]', Peek('Count')+1, 1) as Count

From <> Order By [Commision No], [Lot No] ;

PFA

Re: Generate no based on Lot no.

Wed, 09 Oct 2013 09:03:11 GMT

use autonumber function to get it

load *,AutoNumber(LOT_No) as no1 Resident tablename ;

Re: Generate no based on Lot no.

sujeetsingh — Wed, 09 Oct 2013 09:06:29 GMT

hi,

You can use Recno() as Newlot

Aotohash() function

and even you van have it it UI too

Re: Generate no based on Lot no.

rohit214 — Wed, 09 Oct 2013 09:40:02 GMT

Dear Arya,

We already did that but it is not working please use the attched file. to gegerate the no.

Regards

Rohit

Re: Generate no based on Lot no.

rohit214 — Wed, 09 Oct 2013 09:44:14 GMT

Dear Sujeet,

Recno will give at your record in which row no .

and we also tried what you have suggest but it is not giving the correct value.

Regards

Rohit.

Re: Re: Generate no based on Lot no.

rohit214 — Wed, 09 Oct 2013 10:10:02 GMT

Dear Tresesco,

one more help i want is

if the lot no is same then the count no is also same for example.

i attched sample file please help me.

Re: Generate no based on Lot no.

rohit214 — Wed, 09 Oct 2013 10:21:11 GMT

Dear Tresesco ,

your previous solution is correct as per what logic i share with you.

but for second issue If you have any idea please share with me.

Regards

rohit

Re: Re: Generate no based on Lot no.

saumyashah90 — Wed, 09 Oct 2013 10:22:28 GMT

Hey Rohit

please see the working example

Please mark answer as correct if you get the output

Re: Re: Re: Generate no based on Lot no.

rohit214 — Wed, 09 Oct 2013 10:57:40 GMT

Dear Sumaya,

one more help i want is

if the lot no is same then count no should also same.

i have attached sample file please help me out to sort that problem.

Regards

Rohit

Re: Re: Re: Generate no based on Lot no.

saumyashah90 — Wed, 09 Oct 2013 10:59:28 GMT

Dude but above answer was correct right?

Re: Re: Re: Generate no based on Lot no.

rohit214 — Wed, 09 Oct 2013 11:04:12 GMT

yes Sir, above answer is correct but now i am facing another problem please help me.

Regards

Rohit

Re: Generate no based on Lot no.

CELAMBARASAN — Wed, 09 Oct 2013 11:19:42 GMT

Hi,

Try with AutoNumber function

LOAD Comm_No,

LOT_No,

AutoNumber(LOT_No, Comm_No) AS Output

FROM

dATA.xlsx

(ooxml, embedded labels, table is Sheet1);

Hope that helps

Celambarasan

Re: Generate no based on Lot no.

saumyashah90 — Wed, 09 Oct 2013 11:20:27 GMT

Dude i have a question for this
i.e you should not have repetitive data .

Re: Re: Generate no based on Lot no.

rohit214 — Wed, 09 Oct 2013 11:26:59 GMT

Dear Sir,

Please use this file.

Regards

Rohit

Re: Re: Generate no based on Lot no.

rohit214 — Wed, 09 Oct 2013 11:31:15 GMT

Dear Sir,

I am not able to get you.

Regards

Rohit

Re: Re: Generate no based on Lot no.

saumyashah90 — Wed, 09 Oct 2013 11:32:05 GMT

Please check this for your use.

mark Correct if it is Correct

Re: Re: Re: Generate no based on Lot no.

CELAMBARASAN — Wed, 09 Oct 2013 11:36:10 GMT

PFA