Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rohit214
Creator III
Creator III

Generate no based on Lot no.


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 noLot no.reuired output
201282591201101

201282591201

11

2
201282591201123
201282591201134
201282591201145
201282591201156
201282591201167
201282591201178

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

22 Replies
saumyashah90
Specialist
Specialist

Hey Rohit

please see the working example

Please mark answer as correct if you get the output

rohit214
Creator III
Creator III
Author

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

saumyashah90
Specialist
Specialist

Dude but above answer was correct right?

rohit214
Creator III
Creator III
Author

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

Regards

Rohit

CELAMBARASAN
Partner - Champion
Partner - Champion

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

saumyashah90
Specialist
Specialist

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


rohit214
Creator III
Creator III
Author

Dear Sir,

Please use this file.

Regards

Rohit

rohit214
Creator III
Creator III
Author

Dear Sir,

I am not able to get you.

Regards

Rohit

saumyashah90
Specialist
Specialist


Please check this for your use.

mark Correct if it is Correct

CELAMBARASAN
Partner - Champion
Partner - Champion

PFA