topic Re: Autonumber not working ? in App Development

Autonumber not working ?

stockisteven — Fri, 22 Dec 2017 21:47:05 GMT

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

Re: Autonumber not working ?

luismadriz — Fri, 22 Dec 2017 21:58:51 GMT

Hi,

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

Cheers,

Luis

Re: Autonumber not working ?

stockisteven — Fri, 22 Dec 2017 22:01:50 GMT

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.

Re: Autonumber not working ?

luismadriz — Fri, 22 Dec 2017 22:17:12 GMT

Hi,

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

Re: Autonumber not working ?

stockisteven — Fri, 22 Dec 2017 22:19:26 GMT

argh it was the second field ! Thanks !

Re: Autonumber not working ?

rwunderlich — Fri, 22 Dec 2017 22:19:33 GMT

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