topic interactive sort with RowNo(Total) does not work in QlikView

interactive sort with RowNo(Total) does not work

Wed, 29 Sep 2010 12:44:18 GMT

I add the expression RowNo(Total) to a table and the interactive sort on all other expressions does not work anymore.

Please see attached example.

Many thanks for your assistance.

Daniel

PS: there is as similar question, suggesting to remove the text-sort criteria - which does not solve my problem.

interactive sort with RowNo(Total) does not work

renjithpl — Wed, 29 Sep 2010 12:59:59 GMT

Hi Daniel,

Just try promoting your columns in the sort tab.

Promote RowNo(Total) top (Priority)

Regards

Ren

interactive sort with RowNo(Total) does not work

Wed, 29 Sep 2010 13:10:36 GMT

I don't understand.

I would like to enable the interactivity, that the analyser can change the sorting.

Example: sort by Sales, descending; than sort by Qty, ascending...,

however, the rowno() expression should show a "1" in the first line, "2" in the second, and so on.

How can I enable the interactive sort?

interactive sort with RowNo(Total) does not work

Wed, 29 Sep 2010 13:12:30 GMT

Is this u r looking for ??

Bhushan N

interactive sort with RowNo(Total) does not work

Wed, 29 Sep 2010 13:40:55 GMT

The sort by dimension (Artikel, Lieferant) does work, but not the sort by expression (Sales, Qty).

interactive sort with RowNo(Total) does not work

Tue, 30 Nov 2010 12:28:13 GMT

Hi there,

I have the same problem!

If you use the Rowno(total) as expr in a straight table with multiple dimensions and one (or more) other expression, if you want to sort the table by the expression (Descending) the sort will be run inside the segment (see the definition of the segment using the Help) as for the Rowno() without the "total" qualifier then the sort wil be reset each time the segment will change.

If I exclude the Rowno(total) the sort works fine based on the value of the expression but i can't have the a rowindex.

Any suggestion on an alternative way to put a rowindex in a straight table?

thanks a lot in advance.

interactive sort with RowNo(Total) does not work

Fri, 17 Dec 2010 19:47:38 GMT

Anyone with an answer to this? I have a Group as the dimension (Store) and an expression (sum(Sales). If I use the Rowno() as expression I can't sort by Sales Desc.....it is overriding and using the Group instead even though I explicitly changed the expression to the top of the sort order.

All I wish to do is generate a row number so when the user scrolls down a table he can see ranking (e.g. rowno) based on the interactive sort.

interactive sort with RowNo(Total) does not work

Tue, 28 Dec 2010 15:40:11 GMT

Hi,

I have the same problem, When I use rowno() function, Straight table looses the sort capability.
Is It a bug??

Please help!

interactive sort with RowNo(Total) does not work

syed_muzammil — Tue, 28 Dec 2010 15:56:17 GMT

Hi,

You can jus add this expression in your table as a Column

=1+IF(isnull(Above(a)),0,Above(a))

If you have more than one dimension in your Table then use

=1+IF(isnull(Above(total a)),0,Above(total a))

Where 'a' is the column name for the same expression. 😄

interactive sort with RowNo(Total) does not work

syed_muzammil — Tue, 28 Dec 2010 16:11:45 GMT

Hi,

Sorryyy, Even this is not Working 😄

interactive sort with RowNo(Total) does not work

Miguel_Angel_Baeyens — Tue, 28 Dec 2010 16:53:27 GMT

Hello,

Don't know if this is a bug but it's documented in the Reference Manual under the RowNo() that charts will not be ordered by Y value nor straight tables by expressions.

Hope this helps

interactive sort with RowNo(Total) does not work

Mon, 14 Feb 2011 15:54:35 GMT

I know you've probably figured out another workaround by now, but I wanted to offer a suggestion that I just tried and worked.

I added an Expression that does a Count(Distinct ID) of a unique field in the straight table. In my case, it is an ID. I chose the Full Accumulation box for this Expression. This solves the Row # problem and allows all Expressions to be sorted.

Thanks,

Aline Koch

interactive sort with RowNo(Total) does not work

Mon, 20 Jun 2011 11:25:43 GMT

this is working well.but u have to sort by expression sum(sales) desc

thanks a lot

interactive sort with RowNo(Total) does not work

Tue, 29 Nov 2011 13:08:32 GMT

Alternatively you can add an expression "=1" with Full Accumulation to get the same result.

Lionel

Re: interactive sort with RowNo(Total) does not work

Fri, 25 Jul 2014 16:16:26 GMT

Aline.Koch and LionelBdv: Thank you for your responses! They worked great for me for this problem

Re: interactive sort with RowNo(Total) does not work

m_m_fr — Wed, 06 Feb 2019 16:33:17 GMT

Hi Everyone,

and Hi Aline.Koch and LionelBdv,

I'm having the same issue :

I added a RowNo(Total) Expression in order to put a number on each line, but impossible to sort my expressions.

=> Can you send me a QV app to see how you manage to succeed ?

Thank you.

Re: interactive sort with RowNo(Total) does not work

shokyee4869 — Mon, 16 Sep 2019 14:18:40 GMT

Could you provide an example or sample? We would like to know how you solve this problem.

Thank you

Re: interactive sort with RowNo(Total) does not work

somebody555 — Mon, 05 Jul 2021 09:15:01 GMT

I have same problem with RowNo(TOTAL)

And I cannot add Full Accumulation (I have more that two dimension in table).

Please help!