Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
Autonumber(Name2,SpecialtyDMis) as [HighestDMisSpecialty]
Order by Name2,Count Desc;
Drop table [SurgeonUpdate2];
My mistakle, please use this: autonumber(Name2&'-'&SpecialtyDMis,Name2)
View solution in original post
Please try autonumber(Recno(),Name2&'-'&SpecialtyDMis)
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.
argh it was the second field ! Thanks !
Your code should be:
Number each new value of SpecialtyDMis and reset the counter for each new Name2.