Autogeneration of a number at front end

[Anonymous]

Hello All,

How to generate a auto number at front end in qlikview?

I tried rowno() but its not working...

any other function?

Regards,

Balraj

[#2]

Use a function in the second parameter to count the number of items

eg Valueloop (0,count(distinct FieldName))

If this doesn't work, put the function in a variable, then use the variable.

EG variable1 =  =count(distinct FieldName)

dimension in chart = valueloop(0,variable1)

Erica

[Anonymous]

Tried both the thing.

Repeating the records multiples time with 2nd options.

[#4]

Hi Balraj, could you describe in more detail what the issue is when you say

Repeating the records multiples time with 2nd options.

?what doyou get?

Erica

[Anonymous]

This is what I had tried:

Variable=count(distinct(ID))

=valueloop(1,variable,1)

but it is assigning unique SNo to one ID multiple time say:

SNo  ID

1       101

2        101

3        101

like this.......................

[#6]

You could probably also use a rank function to get what you want then

=aggr(rank(total [ID]),[ID])

This would return the rank of the ID's and would be sensitive to selections.

Erica

[Anonymous]

Not working!!

Giving garbage values....

[#8]

what is it giving?

Erica

[#9]

Hi,

Please try with Rowno(Total) in expression

Regards,

Joshmi

[CELAMBARASAN]

Hi,

Did you working with Straight Table?

If it so add RowNo() as expression and move it to the 1st place