Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Serial no.

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

Tags (2)
5 Replies
Not applicable

Re: Serial no.

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

Re: Serial no.

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

Not applicable

Re: Serial no.

Manish,

Check the attachment to see if it helps.

Regards,

-Khaled.

er_mohit
Honored Contributor II

Re: Serial no.

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

Re: Serial no.

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!!!