Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stockisteven
Contributor
Contributor

Autonumber not working ?

Blown away at what I am doing wrong.

Trying to get an "AutoNumber" for Name and SpecialtyDMis.. but yet it acts as if the SpecialtyDMis doesn't exist ?

Any ideas? Thanks

Example fake data below.

[SurgeonUpdate3]:

load*,

Autonumber(Name2,SpecialtyDMis) as [HighestDMisSpecialty]

Resident [SurgeonUpdate2]

Order by Name2,Count Desc;

Drop table [SurgeonUpdate2];

QlikError.jpg

1 Solution

Accepted Solutions
luismadriz
Specialist
Specialist

Hi,

My mistakle, please use this: autonumber(Name2&'-'&SpecialtyDMis,Name2)

View solution in original post

5 Replies
luismadriz
Specialist
Specialist

Hi,

Please try autonumber(Recno(),Name2&'-'&SpecialtyDMis)


Cheers,


Luis

stockisteven
Contributor
Contributor
Author

Hi Luis,

Tried but it didn't work.

I think the first fieldname in the bracket is what is used to reset the count for each name - rowno() will always be different so it'll always give a ranking of 1.

luismadriz
Specialist
Specialist

Hi,

My mistakle, please use this: autonumber(Name2&'-'&SpecialtyDMis,Name2)

stockisteven
Contributor
Contributor
Author

argh it was the second field ! Thanks !

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Your code should be:

Autonumber(SpecialtyDMis, Name2)


Number each new value of SpecialtyDMis and reset the counter for each new Name2.


-Rob

http://masterssummit.com

http://qlikviewcookbook.com