Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

guruprem
Contributor III

Sno in a Qlik Sense Table

Hi,

One of my user would like to see the data in Qlik Sense in typical table with Sno as column one. Idea is, he wants export this table it to Excel and do some more activity such as sharing with others.  Please suggest how to generate Serial numbers dynamically ?

1 Solution

Accepted Solutions
Not applicable

Re: Sno in a Qlik Sense Table

Hi Guruprem,

Try using RowNo(Total)

Regards,

Rohan

7 Replies
arulsettu
Honored Contributor III

Re: Sno in a Qlik Sense Table

may be while loading the excel add this

load RowNO() as Sno,

       ............

       ............

     from................

guruprem
Contributor III

Re: Sno in a Qlik Sense Table

Arul,

In that way it might be static Sno. To be specific when it comes to front end, that Sno does not come as 1,2,3 if my selection has only 3 rows it may come some thing as 1,6,10 since this Sno is generated at the back end.

arulsettu
Honored Contributor III

Re: Sno in a Qlik Sense Table

can you post some sample...

arulsettu
Honored Contributor III

Re: Sno in a Qlik Sense Table

or try

load RecNo() as Sno

Not applicable

Re: Sno in a Qlik Sense Table

Hi Guruprem,

Add a new Measure in your table chart with Expression as RowNo().

It changes according to selection dynamically.

Regards,

Rohan

guruprem
Contributor III

Re: Sno in a Qlik Sense Table

Hi,

Intially I thought Rowno() as measure would work , but when I implement something funny like below has happend (all that row populated only with 1). Any suggestion?

Rowno().PNG

Not applicable

Re: Sno in a Qlik Sense Table

Hi Guruprem,

Try using RowNo(Total)

Regards,

Rohan