Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
may be while loading the excel add this
load RowNO() as Sno,
............
............
from................
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.
can you post some sample...
or try
load RecNo() as Sno
Hi Guruprem,
Add a new Measure in your table chart with Expression as RowNo().
It changes according to selection dynamically.
Regards,
Rohan
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?
Hi Guruprem,
Try using RowNo(Total)
Regards,
Rohan