topic Re: serial no in straight table in QlikView

serial no in straight table

engr_farhanqadr — Tue, 14 Nov 2017 05:54:26 GMT

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

Re: serial no in straight table

Anil_Babu_Samineni — Tue, 14 Nov 2017 05:58:24 GMT

Can u describe more on this?

Re: serial no in straight table

satheshreddy — Tue, 14 Nov 2017 05:59:17 GMT

Hi Farhan,

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

Regards'

sathesh

Re: serial no in straight table

avinashelite — Tue, 14 Nov 2017 06:05:57 GMT

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

Aggr(RowNo(),Dimension)

Re: serial no in straight table

engr_farhanqadr — Tue, 14 Nov 2017 06:46:57 GMT

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

Re: serial no in straight table

engr_farhanqadr — Tue, 14 Nov 2017 06:49:31 GMT

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

avinashelite — Tue, 14 Nov 2017 09:34:22 GMT

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

Re: serial no in straight table

pradosh_thakur — Tue, 14 Nov 2017 09:47:37 GMT

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

Re: serial no in straight table

engr_farhanqadr — Tue, 14 Nov 2017 10:43:27 GMT

Dear avinash,

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

Re: serial no in straight table

engr_farhanqadr — Tue, 14 Nov 2017 10:44:57 GMT

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

Re: serial no in straight table

avinashelite — Tue, 14 Nov 2017 10:50:04 GMT

could you share a sample app ??