topic Sorting Issues in QlikView

Sorting Issues

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I need Help at Gui Application (Front end) Level

I have this Chart:

Here in above Chart I am using Rank function to calculate Top 3 and Rest will Fall under Others.

I need following things:

1) Others Category will always come below after Top 3 Rank Holders.

2) Month should display as per the Latest Month.

The Month should be Mar, Feb, Jan rather than Jan, Feb, Mar.

I have sorted the Chart as per the Latest Month. See the Sort Expression Tab.

Anyone has faced such scenario during their Project than please provide the solution.

I have attached the qvw for reference.

Regards

Cire

Re: Sorting Issues

sunny_talwar — Mon, 26 Sep 2016 16:15:27 GMT

This

Sort for your 1st dimension (Ascending)

Match(If(Aggr(Rank(Sum(Amount)),Code)<=3,Code,'Others'), 'Others')

Sort for your 2nd dimension (Descending)

Month(Date#(Month_New, 'MMM'))

Re: Sorting Issues

Mon, 26 Sep 2016 19:29:26 GMT

Hi Sir

Great Solution.

But I want Max Month wise Amount Sorting. Like this:

Can we get this end Result. I have done sorting in Sort Expression like this Sum({<Month={$(vMaxMonth)}>}Amount)

Is there any other way.

Regards

Cire

Re: Sorting Issues

Tue, 27 Sep 2016 17:07:51 GMT

Sir Need your help on this.

Re: Sorting Issues

sunny_talwar — Tue, 27 Sep 2016 17:38:15 GMT

May be sort using this:

If(Aggr(NODISTINCT Rank(Sum(Amount)),Code)<=3,Sum(Value))

Re: Sorting Issues

sunny_talwar — Tue, 27 Sep 2016 17:46:51 GMT

I just responded. See my response below

Re: Sorting Issues

Tue, 27 Sep 2016 18:36:46 GMT

Thanks Sir

You are Great. Your Solutions are small and Powerful.

That's the Beauty of Real and Genuine Coder.

Learning a lot of things from you.

I am just following your footsteps.

I have modified your Expression like this:

If(Aggr(NODISTINCT Rank(Sum({<Month={$(vMaxMonth)}>}Amount)),Code)<=3,Sum({<Month={$(vMaxMonth)}>}Amount))

and it worked.

Many-Many Thanks Sir to you.

Regards

Cire

Re: Sorting Issues

sunny_talwar — Wed, 28 Sep 2016 00:51:41 GMT

No problem. I am glad I am able to help you learn.

Best,

Sunny