Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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???
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
can you please provide expression for frequency column. as i am not able to open qvw provided by you.
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
Like this ?
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.
If this meets your requirement Now you just go to sort tab and promote Frequency dimension to top
Dear Parthesh,
Thanks a ton for your help! It works like a charm!
Best Regards
QianNing