topic Re: sorting in QlikView

sorting

prma7799 — Tue, 28 Jul 2015 10:21:39 GMT

Hi All,

I have one pivot table and i am taking 5 calculated dimension for top 5 product or we can say top 5 record and other record come as REST.

Now my data is coming properly but i need sorting in proper way.

For example

REST	FY16	2,900
P LOGISTICS	FY16	665
D INDIA	FY16	454
A.K.SERVICES	FY16	404
N.S.ARMA	FY16	387
MI LOGISTICS	FY16	384

but I required below output... I want REST record below to top 5 record.


P LOGISTICS	FY16	665
D INDIA	FY16	454
A.K.SERVICES	FY16	404
N.S.ARMA	FY16	387
MI LOGISTICS	FY16	384

REST

FY16

2,900

Re: sorting

dickelsa — Tue, 28 Jul 2015 10:22:51 GMT

Hi,

Can you please tell me if there is any logic behind the sorting?

Regards,

Dick

Re: sorting

prma7799 — Tue, 28 Jul 2015 10:26:42 GMT

Yes. I put ytd sales expression as descending mode in sorting tab

Re: sorting

dickelsa — Tue, 28 Jul 2015 10:34:50 GMT

You should check then if the sorting orders on all other dimensions are switched of, can you please attach your dashboard for more insight?

Re: sorting

prma7799 — Tue, 28 Jul 2015 10:38:56 GMT

All other dimension are switched off in sort tab. It is not possible to attache doc

Re: sorting

dickelsa — Tue, 28 Jul 2015 11:20:57 GMT

Maybe you need to use the expression in the sorting, instead of sorting on expression?

Re: sorting

Tue, 28 Jul 2015 11:58:38 GMT

Hi,

Go to Sort tab,

Use Sort by expression option

If(Column_name ='P LOGISTICS',1,

If(Column_name ='D INDIA',2,

If(Column_name ='A.K.SERVICES',3,

If(Column_name ='N.S.ARMA',4,

If(Column_name ='MI LOGISTICS',5,

If(Column_name ='REST',6))))))

i think this should work.

Regards,

Re: sorting

dickelsa — Wed, 29 Jul 2015 14:07:09 GMT

Yes but this solution works only for 1 situation, but if N.S.ARMA has a lesser lesser value then A.K.SERVICES, it does not switch places... again, if you attach an exemple of your dashboard, it would be more clear..

Re: sorting

antoniotiman — Wed, 29 Jul 2015 14:18:43 GMT

Hi,

If Dim is Your Dimension, in Tab Sort Try expression

If(Dim <> 'REST,Rank(Sum(Value)),9999999)

Regards,

Antonio

Re: sorting

dickelsa — Wed, 29 Jul 2015 14:27:06 GMT

If(Dim <> 'REST',Rank(Sum(Value)),9999999)

you forgot a quote mark

Re: sorting

antoniotiman — Wed, 29 Jul 2015 14:30:40 GMT

Yes,I'm sorry.

Re: sorting

prma7799 — Thu, 30 Jul 2015 05:00:07 GMT

Hi Antonio,

I tried your solution Rest values is go down but sorting is not coming properly.

PFA.

Thanks

Re: sorting

prma7799 — Thu, 30 Jul 2015 05:29:47 GMT

Hi sunindia‌,

Can you please help me out.

Thanks

Re: sorting

Digvijay_Singh — Thu, 30 Jul 2015 05:30:40 GMT

For me the suggested expression is working, please check. Hope u hv switched off Product sorting check boxes.

Re: sorting

prma7799 — Thu, 30 Jul 2015 05:39:55 GMT

Hi Digvijay,

I checked that one but sorting is not coming properly.

Thanks