Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
ramachandra_gee
Contributor III
Contributor III

distinct no for field

Hi Team,

could any one please suggest how to generate distinct no for site filed here.

site siteno

inida 1

us 2

kenada 3

   

sitestatedisitnctsales
Indiaapongole80
Indiaapnell85
indiabhpparadise23
indiabhpcellorium45
usremedycalom86
usremedysiral75
kenadakalosarichel66
kenadakalosasilaj89
kenadasumeraaparlak25

Thanks,

Ram.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Front-end ? Try using chart like:

Straight table:

Dim: site

Exp: Rowno()

For script:

Load

       *,

       AutoNumber(site) as SiteNo

From <>;

View solution in original post

2 Replies
tresesco
MVP
MVP

Front-end ? Try using chart like:

Straight table:

Dim: site

Exp: Rowno()

For script:

Load

       *,

       AutoNumber(site) as SiteNo

From <>;

Anil_Babu_Samineni

May be this

site & ' ' & RowNo() as site

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful