Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
engr_farhanqadr
Contributor

serial no in straight table

Hi Folks,

I have a situation where I need to incorporate serial no in straight table also if I click on any measure column to sort the serial no will be generated according to that.

Thanks.

Farhan

Tags (1)
10 Replies

Re: serial no in straight table

Can u describe more on this?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
satheshreddy
Contributor III

Re: serial no in straight table

Hi Farhan,

can you elaborate this, do you need rowno as a exp or dimension?

Regards'

sathesh

Re: serial no in straight table

Try like this in the expression , you should get the result

Aggr(RowNo(),Dimension)

engr_farhanqadr
Contributor

Re: serial no in straight table

I just need serial no in starting whether in dimension or expression, I have a straight table in which I have different designations and their sales MTD and YTD eg. If I click on YTD it will sort the column and the serial should not be disturbed by this.

Thanks

engr_farhanqadr
Contributor

Re: serial no in straight table

I used this but when I click on any measures(eg YTD sales) it changed the order of serial no., serial no should not be disturbed by sorting of measures.

Thanks

Re: serial no in straight table

If that the case define the rowno() in hte script level that will not change

pradosh_thakur
Honored Contributor II

Re: serial no in straight table

try ROWNO() in expression if you have only one dimension if more than one dimesnsion try rowno(total)

Learning never stops.
engr_farhanqadr
Contributor

Re: serial no in straight table

Dear avinash,

I wrote in the script but the resultant column is not starting with 1.

engr_farhanqadr
Contributor

Re: serial no in straight table

Thanks, serial no are now not changing but the expressions became un-sortable