Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

autonumber?


autonumber(sales)*100 as nsales  ?   what it returns ?

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

It will AutoNumber each distinct Sales with 1, 2 ,3 ,4 etc.. and then multiply with 100

So if you have

Sales as

100

100

100

120

120

130

it will give

Sales     nsales

100         100

100         100

100          100

120          200

120          200

130          300

View solution in original post

2 Replies
saurabh5
Creator II
Creator II

it will give you the output as 100,200,300 depending on the distinct rows of sales you have in your data.

Regards

Saurabh

MK_QSL
MVP
MVP

It will AutoNumber each distinct Sales with 1, 2 ,3 ,4 etc.. and then multiply with 100

So if you have

Sales as

100

100

100

120

120

130

it will give

Sales     nsales

100         100

100         100

100          100

120          200

120          200

130          300

View solution in original post