topic Re: sorting issue in QlikView

sorting issue

upaliwije — Sun, 22 Sep 2019 08:30:41 GMT

Hi friends

I have below pivot table in my Qv Doc.

Here my dimension is a calculated with following syntax,

=If(Aggr(Rank(Sum({<VEHICLE_TYPE={'CAR/JEEP'}>}POLNos)), [MAKE])<=8, [MAKE], 'Others')

I want to sort this in such a way Rows representing others should come immediately above total rows . Kindly help me with sorting expression

upaliwije — Mon, 23 Sep 2019 06:56:01 GMT

Hi Friends,

Can Someone help me pls.

StarinieriG — Mon, 23 Sep 2019 08:41:32 GMT

Hi,

try with this expr

If(Rank(Sum({<VEHICLE_TYPE={'CAR/JEEP'}>}POLNos))<=8, Rank(Sum({<VEHICLE_TYPE={'CAR/JEEP'}>}POLNos)), 9)

upaliwije — Mon, 23 Sep 2019 08:50:21 GMT

Thanks

But It does not work please

Brett_Bleess — Tue, 08 Oct 2019 13:38:36 GMT

Likely going to need to attach a QVW file on this one, so folks can see underlying data model as well...

Regards,
Brett