Can we have a chance to generate serial no dynamically in Qlikview straight table. For running data.

[#1]

‌

Hi All

Can we have a chance to generate serial no dynamically in Qlikview straight table. For running data.

Ex:

Suppose in table 100 records

Normally the Sno shows 1-100

If I go to any selection, based on that selection the data display in that table with the filtered data is about to 20 records , that time also the Sno start with 1 and ends with 20.

If clear then it comes to normal numbering 1-100

Can any one help me out

Regards,

AR UMAMAHESH

[Oleg_Troyansky]

I'm not sure I completely understand the question, but it sounds like you are looking for the function RowNo().

cheers,

Oleg Troyansky

Check out my new book QlikView Your Business - The Expert Guide for QlikView and Qlik Sense

[#3]

Hi

Row number works in script it assigne a record value for each and every record while loading into Qlikview. That is static value.

I need dynamic row number in front end, that will works always dynamically 

[swuehl]

There is also an inter record chart function called RowNo():

RowNo ‒ QlikView

Just create an expression

=Rowno(TOTAL)

[#5 · Accepted solution]

Hi All,

Finally i got the dynamic row number, for now it is working fine, but i am not satisfied fully.

For your reference i attached doc.

[Anil_Babu_Samineni]

Can you try for me something like below

LOAD *,If(Peek(OrderDate)=OrderDate,Peek(Seq)+1,1) as Seq;

LOAD OrderID,

     OrderDate,

     Customer,

     Employee,

     Region,

     Product,

     Cost,

     Quantity,

     [Final Price],

     RecNo() as ID

FROM

(ooxml, embedded labels, table is Sales);

And then Use, Dimensions and Expressions like below

Dim -- Seq,Employee

Expression -- Sum([Final Price])