Sno in a Qlik Sense Table

[guruprem]

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 ?

[arulsettu]

may be while loading the excel add this

load RowNO() as Sno,

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

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

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

[guruprem]

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]

can you post some sample...

[arulsettu]

or try

load RecNo() as Sno

[#6]

Hi Guruprem,

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

It changes according to selection dynamically.

Regards,

Rohan

[guruprem]

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?

[#8 · Accepted solution]

Hi Guruprem,

Try using RowNo(Total)

Regards,

Rohan