topic Re: Sorting of straight table based on expression value in descending order in QlikView

Sorting of straight table based on expression value in descending order

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

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)

Best Regards

Re: Sorting of straight table based on expression value in descending order

kakani87 — Sat, 24 Feb 2018 08:09:02 GMT

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???

Re: Sorting of straight table based on expression value in descending order

s10157754 — Sat, 24 Feb 2018 08:15:57 GMT

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

Re: Sorting of straight table based on expression value in descending order

parthesh — Sat, 24 Feb 2018 08:21:54 GMT

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

Re: Sorting of straight table based on expression value in descending order

s10157754 — Sat, 24 Feb 2018 08:36:20 GMT

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

Re: Sorting of straight table based on expression value in descending order

kakani87 — Sat, 24 Feb 2018 09:03:46 GMT

Like this ?

Re: Sorting of straight table based on expression value in descending order

parthesh — Sat, 24 Feb 2018 09:06:00 GMT

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.

Re: Sorting of straight table based on expression value in descending order

kakani87 — Sat, 24 Feb 2018 09:35:33 GMT

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

Re: Sorting of straight table based on expression value in descending order

s10157754 — Sat, 24 Feb 2018 11:51:57 GMT

Dear Parthesh,

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

Best Regards

QianNing