Autonumber not working ?

[stockisteven]

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];

[luismadriz]

Hi,

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

Cheers,

Luis

[stockisteven]

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 · Accepted solution]

Hi,

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

[stockisteven]

argh it was the second field ! Thanks !

[rwunderlich]

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