topic Re: Sort on straight table using class function in QlikView

Sort on straight table using class function

Tue, 25 Mar 2014 12:39:29 GMT

Hi all,

Please see below. Actually I want to sort on First Column(Net Sales Bands).

I am using expression.

replace(replace(CLASS(Aggr(sum({<DECDDT1 = {">=$(vFromDate)<=$(vToDate)"}>}[Net Sales]),accpg_accno),1000,'-'),'<=',''),'<','')

its does not sort properly if I double click on column heading. is there any way to sort as numbers.

Thanks

Vinay

Re: Sort on straight table using class function

MK_QSL — Tue, 25 Mar 2014 12:51:10 GMT

DUAL(replace(replace(CLASS(Aggr(sum({<DECDDT1 = {">=$(vFromDate)<=$(vToDate)"}>}[Net Sales]),accpg_accno),1000,'-'),'<=',''),'<',''), CLASS(Aggr(sum({<DECDDT1 = {">=$(vFromDate)<=$(vToDate)"}>}[Net Sales]),accpg_accno),1000,'-'))

Now go to sort tab...

Select Number Value by Asc or desc

Re: Sort on straight table using class function

Nicole-Smith — Tue, 25 Mar 2014 12:53:16 GMT

By using the replaces, you're changing the result of the class, which should be a dual, to a text string. Simply getting rid of the replaces should solve this problem and allow it to sort as a number (you can use this as a Sort by Expression on the Sort tab):

CLASS(Aggr(sum({<DECDDT1 = {">=$(vFromDate)<=$(vToDate)"}>}[Net Sales]),accpg_accno),1000,'-')

Re: Sort on straight table using class function

Tue, 25 Mar 2014 13:10:35 GMT

Thanks Manish & Nicola,

Its working perfect.

Regards

Vinay