Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Folarin
Contributor II
Contributor II

How do I create a counter field for product IDs

 

Hi,

 

How do I create a counter field for product IDs?

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

In your load script in a load statement you could use the AutoNumber() function:

 

LOAD
    AutoNumber(ProductID,'ProdIdCounter') AS ProuctIdCount,
    ....

 

View solution in original post

3 Replies
petter
Partner - Champion III
Partner - Champion III

In your load script in a load statement you could use the AutoNumber() function:

 

LOAD
    AutoNumber(ProductID,'ProdIdCounter') AS ProuctIdCount,
    ....

 

Folarin
Contributor II
Contributor II
Author

can you also use a flag? If true, how

petter
Partner - Champion III
Partner - Champion III

Yes you can use flags just like any type of analytics tool... But how and where you create it depends on the data model and how you want to use the flag later on in your expressions and your analysis.

[ NOTE: to show any contributor that you like and appreciate their answers please CLICK the like icon (thumbs up) ]