Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Serial no.

I want to show Serial No. in front end in the report. How can it be done.

5 Replies
Not applicable
Author

Hi,

You can add rowno(Total) as an expression in your chart/table, and promote it to the first column.

Hope it helps.

Regards,

-Khaled.

Not applicable
Author

It's not working when i apply this on my report it's showing as '-' & disappearing the report further.

Not applicable
Author

Manish,

Check the attachment to see if it helps.

Regards,

-Khaled.

er_mohit
Master II
Master II

write in script where you load your table like

load a,

b,

c,..............,

rowno() as count

from table;

hope it helps.

then in front end in your expression use count it will automatically made field

Not applicable
Author

Hey this works when we take this in expressions & not in calculated dimension. Also if we are showing pivot table then this will be of no help because we can't promote this before the dimensions.

thnx for the help!!!