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

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

Wed, 25 Nov 2020 16:16:04 GMT

‌

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

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

Oleg_Troyansky — Tue, 12 Apr 2016 18:21:15 GMT

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

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

Sat, 16 Apr 2016 17:03:21 GMT

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

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

swuehl — Sat, 16 Apr 2016 17:24:40 GMT

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

RowNo ‒ QlikView

Just create an expression

=Rowno(TOTAL)

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

Wed, 16 Nov 2016 09:44:27 GMT

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.

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

Anil_Babu_Samineni — Wed, 16 Nov 2016 11:54:17 GMT

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])