topic Re: Sorting query in QlikView

Sorting query

kvr9 — Wed, 25 Nov 2020 16:16:04 GMT

Scenario :

There are 5 companies A,B,C,D,E with their amount .

Load inline

Company Amount

A ,50

B,10

C,30

D,15

E,60

I want to sort the companies keep one company (C) as 1st column which is fixed and then followed by other companies sorted based on values .

The desired output should be as below in descending order on bar chart :

C,E,A,D,B

Re: Sorting query

prma7799 — Tue, 10 Oct 2017 07:46:24 GMT

Like this we can do...

Re: Sorting query

mdmukramali — Tue, 10 Oct 2017 07:48:24 GMT

Dear,

You can use the below Expression in the sort:

pick(1+match(Company,'C'),rank(sum(Amount)),0)

Re: Sorting query

kvr9 — Tue, 10 Oct 2017 08:39:35 GMT

Thank you for your response.

I tired above options but the sort is not working as desired ,neither it is sorting based on Amount nor descending order.

below is the snapshot of my result.

Request you to help in sorting the bar chart

Re: Sorting query

mdmukramali — Tue, 10 Oct 2017 09:13:57 GMT

Hi,

It seems you are using 2 Dimensions and 1 Expression in the Chart.

I also tried and it's working fine.

can you share your sort tab properties screen shot?

Re: Sorting query

kvr9 — Wed, 11 Oct 2017 06:26:24 GMT

It works perfectly.

Many thanks Mohammed.

Re: Sorting query

CELAMBARASAN — Wed, 11 Oct 2017 06:38:41 GMT

Hi Vijaya Reddy

Please always close the thread (by Marking Correct/Helpful answer), once any of the response solves your query.

-Celambarasan

Re: Sorting query

kvr9 — Wed, 11 Oct 2017 07:20:22 GMT

Hi ,

I have an additional requirement ,I am using two expression so used a group function in my chart.

The sort function is reflecting correctly to only one expression and not to the 2nd one.

How can I resolve this issue.

Thank In advance.

Re: Sorting query

mdmukramali — Wed, 11 Oct 2017 08:05:54 GMT

Hi,

Can you upload sample file data.

Re: Sorting query

kvr9 — Thu, 12 Oct 2017 08:07:02 GMT

Hi Please find the sample data and qvw.

Can you also help in calculating the percentage of sales by product

Re: Sorting query

mdmukramali — Thu, 12 Oct 2017 08:45:44 GMT

HI,

PFA

I have applied the same sort condition it's working fine.

Thanks,

Mohammed Mukram

Re: Sorting query

kvr9 — Thu, 12 Oct 2017 08:58:59 GMT

Amazing it works now.

Thanks a lot Mohammed.