Qlik Community

Qlik Sense App Development

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

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
luismadriz
Valued Contributor

Re: Autonumber not working ?

Hi,

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

5 Replies
luismadriz
Valued Contributor

Re: Autonumber not working ?

Hi,

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


Cheers,


Luis

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.

luismadriz
Valued Contributor

Re: Autonumber not working ?

Hi,

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

stockisteven
New Contributor

Re: Autonumber not working ?

argh it was the second field ! Thanks !

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

Community Browser