Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

vikasshana
New Contributor III

Need help in sorting the value in descending order

Hi All,

Thank you for helping me in some of the question which I posted earlier. I've a new requirement in our project where we need to sort the values from highest to low. Below tables tells you in detail of what I'm getting and what I would like to see.

I've a table which has device information and some columns with expression as 'SUM' and below is the table which I'm getting.

 

DeviceHigh CountMedium CountLow Count
A244
B422
C655
D466
E112
F435

I would like to see some thing like below.

 

DeviceHigh CountMedium CountLow Count
C666
D455
F445
B434
A222
E112

The difference between the two tables are it is sorting the High, Medium and Low from Highest to Lowest and here 'Device' is my column name and High count is 'SUM(HIGH'), Medium Count is 'SUM(MEDIUM)' and Low Count is 'SUM(LOW)' and I'm using Pivot table in my app.

Regards,

Vikas

Tags (1)
7 Replies
MVP
MVP

Re: Need help in sorting the value in descending order

The value of C changed because of the sorting?

Capture.PNG

vishsaggi
Esteemed Contributor III

Re: Need help in sorting the value in descending order

I think he wants to sort on HighCount..

MVP
MVP

Re: Need help in sorting the value in descending order

Make sense, but why are Medium, Low dependent on Dimension?

vishsaggi
Esteemed Contributor III

Re: Need help in sorting the value in descending order

It should not right? Cos he has expressions for High Medium and Low columns.

vishsaggi
Esteemed Contributor III

Re: Need help in sorting the value in descending order

So he wants to sort the high with dependent dimension but Medium and Low as their own sorting ignoring dimensions.

MVP
MVP

Re: Need help in sorting the value in descending order

But that just doesn't make any sense.... in a single chart... if you do this, then you are giving incorrect information to your users

vishsaggi
Esteemed Contributor III

Re: Need help in sorting the value in descending order

Absolutely. He has to correct the given information based on this discussion we had. :-)