topic Re: straight table using RowNO() having issue with sorting in QlikView

straight table using RowNO() having issue with sorting

Sat, 11 Jan 2014 00:08:00 GMT

Hi Guys,

I need to do sorting in a straight table on a chosen column.

I am using RowNo() in this table so sorting is not working and it always sorts by the first column.

Is there any work around of it?

I am using RowNo() in the expression like this...

if(RowNo()<>0 and not IsNull(RowNo()),LinkedTxnType)

to hide ReceivePayment in bold text text from appearing on the Total line.

I also tried to avoid using Rowno() for this purpose and use "No Totals" as TotalMode on the Expression tab but that did not stop the ReceivePayment in bold text text from appearing on the Total line.

So my goal is to

stop the ReceivePayment in bold text text from appearing on the Total line.
do sorting on columns.

Any ideas?

Regards,

Saurabh

Re: straight table using RowNO() having issue with sorting

sundarakumar — Sat, 11 Jan 2014 01:52:33 GMT

Hi Ramya,

Please share a sample app or sample source to understand ur requirements.

1. I think the TOTAL showing in bold with bold Received Payment is data and not total(since they are having txn id) .Please share sample source to confirm.

2.Sorting can be done by any expression just go to sort tab and select the expression u want to sort in and give the condition.Please specify on what condition you want to sort. We can try to help you.

-Sundar

Re: straight table using RowNO() having issue with sorting

khadeer — Sat, 11 Jan 2014 05:12:15 GMT

Hi,

In sort tab u have interactive sort option. Check that option.

Regards,

Khadeer

Re: straight table using RowNO() having issue with sorting

Sat, 11 Jan 2014 16:00:32 GMT

I read on this Sorting Problem for Straight Table that if we are using rowno() then sorting is disabled.

And I can confirm that ReceivePayment and TxnID shown on total line is not data.

I will share a sample app soon.

Re: straight table using RowNO() having issue with sorting

Sat, 11 Jan 2014 17:04:09 GMT

Hi,

Chart Properties -> Expression -> Total Mode (No Totals)

Chart Properties -> Sort Tab -> Sort By

Re: straight table using RowNO() having issue with sorting

whiteline — Sat, 11 Jan 2014 19:03:08 GMT

Hi.

In the cases like "RowNo()<>0 and not IsNull(RowNo())" you can use Dimensionality() instead of RowNo().

So that the sorting should work.

Re: straight table using RowNO() having issue with sorting

Mon, 13 Jan 2014 19:20:54 GMT

I can not use dimensionality() because users have options to remove and add more dimensions.

Re: straight table using RowNO() having issue with sorting

whiteline — Mon, 13 Jan 2014 19:24:14 GMT

Since you check for the grand total line there is no matter what function to use.

add:

Here the solution how to get row numbers without using rowno().

Re: straight table using RowNO() having issue with sorting

Mon, 13 Jan 2014 22:23:09 GMT

My whole purpose of using RowNo() is to find the Total line and remove the text from there.

like this

if(RowNo()<>0 and not IsNull(RowNo()),LinkedTxnType)

is there any other way to detect the total line and achieve the same result?

Re: straight table using RowNO() having issue with sorting

phaneendra_kunc — Mon, 13 Jan 2014 23:28:36 GMT

Try this option...

Enable "Design Grid" -- Menu bar --> design grid.

and right click on the cell you are trying to "unBold" and click on "Custom Format cell"

you will notice "BOLD" is checked..remove that..

Now all Total rows will be unbolded...do it for expressions too..

Regards,

Phani