Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
s10157754
Creator III
Creator III

Sorting of straight table based on expression value in descending order

Dear Qlikview Experts,

Any Ideas on how to sort the straight table in descending order? I have tried to sort by expression, frequency, dimension and play around with all the options under sort tab. But all does not work. I wish to sort my 'Result' based on 'Frequency' Value in descending order, so it will be easier for the user to analysis the data.

(Attached QVW file for your reference)

Capture.PNG

Best Regards

1 Solution

Accepted Solutions
parthesh
Creator
Creator

Thanks for providing excel,

i have created demo, and by promoting count expression to top i am able to sort descending.

it will sort by priority only and you can set priority by "Promote" and "Demote" button.

please find below screenshot.

View solution in original post

8 Replies
kakani87
Specialist
Specialist

Here  3 tables you are displaying and in Machine 100 sort is proper like same you want to show in Machine 200 and Machine 300 tables or anything else???

s10157754
Creator III
Creator III
Author

These 3 tables are just a screenshot of the current situation I was facing now, which was not the correct output that I desired.

The output that I want to achieve is:

Machine 100       Machine 200       Machine 300

Good      5           Bad        5           Good      5

Bad        3           Good      3           Perfect    3

Perfect   3           Perfect   3           Bad         2

Best Regards

parthesh
Creator
Creator

can you please provide expression for frequency column. as i am not able to open qvw provided by you.

s10157754
Creator III
Creator III
Author

Dear Parthesh,

I had attached the sample excel data for your reference.

I had created 3 tables for 3 machines:

(I hide the dimension column) The dimension I put it as: 'Result'

(Result Column) The 1st expression is : =Aggr(Only({<BCNo={100},Result-={'Intermittent','Moderate'}>} Result), Result)

(Frequency Column) The 2nd expression is: =count({<[BCNo] = {100},Result-={'Intermittent','Moderate'}>} [Result])

Best Regards

kakani87
Specialist
Specialist

Like this ?

Sort.png

parthesh
Creator
Creator

Thanks for providing excel,

i have created demo, and by promoting count expression to top i am able to sort descending.

it will sort by priority only and you can set priority by "Promote" and "Demote" button.

please find below screenshot.

kakani87
Specialist
Specialist

If this meets your requirement Now you just go to sort tab and promote Frequency dimension to top

s10157754
Creator III
Creator III
Author

Dear Parthesh,

Thanks a ton for your help! It works like a charm!

Best Regards

QianNing