Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
stockisteven
New 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
Highlighted
luismadriz
Valued Contributor

Re: Autonumber not working ?

Hi,

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

View solution in original post

5 Replies
Highlighted
luismadriz
Valued Contributor

Re: Autonumber not working ?

Hi,

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


Cheers,


Luis

Highlighted
stockisteven
New Contributor

Re: Autonumber not working ?

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.

Highlighted
luismadriz
Valued Contributor

Re: Autonumber not working ?

Hi,

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

View solution in original post

Highlighted
stockisteven
New Contributor

Re: Autonumber not working ?

argh it was the second field ! Thanks !

Highlighted
MVP & Luminary
MVP & Luminary

Re: Autonumber not working ?

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