topic Cyclic Group Sorting order issue. in QlikView

Cyclic Group Sorting order issue.

suresh_qv50 — Mon, 11 Apr 2016 10:42:15 GMT

Hi EveryOne,

I have created 2 Straight tables,

1. Table1(ACH) is created ACHTable (cyclic group ) as dimension.

Group has dimensions Store,BankName,BankRouting,Statementnumber,Attempt,isdirectDeposit etc.

here problem is for bankname and bank routing sorting is not working. i need frequency Desc for Bankname and bankrouting.

for Annualincomebin field the UnAvailable is showing first but we need at last.

2.Same Issue in Dc table too

I Have attached .qvw please go throught it and revert back ASAP.

Thanks in advance.

settu_periasamy — Mon, 11 Apr 2016 16:10:23 GMT

may be like attached?

1.ACH Chart

Promote your Expression (Sent) as Top -> Sort By -> Numeric Value -> Descending

2. DcTable

Promote your Count Expression to top -> Sort By -> Numeric Value-> Descending

Remove other sort by options..

settu_periasamy — Mon, 11 Apr 2016 16:19:37 GMT

Your sample attached

suresh_qv50 — Mon, 11 Apr 2016 16:40:29 GMT

Hi settu_periasamy,

Thanks for immediate response,

That was working in case of bankname and bankrouting perfect. but i need store -->numerical Asc,

Statementnumber --> numerical asc, Attempt --> num asc,

Payfrequency --> Match Exp, like wise etc.

By this change it was changing the remaining dimensions sorting order.

2. In any field have Unavailable, it should be at last of data like

For Exp:

PayFrequency

weekly

Bi_weekly

semi_monthly

Monthly

UnAvailable