Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
d_petrov
Contributor III
Contributor III

Straight table sorting numbers in expressions by clicking the header

Hello,

I can sort the dimension by clicking the header, but how to apply the same behavior to the expressions?

When I click an expression header the numeric values inside are not sorted 😞

For the first dimension I use  =AGGR(Id,.....) , for all expressions I use MAX([value])

Any ideas how to sort the expression (Columns Estimate 1 to 5) by clicking them and receive the non-zero values at the top ?

Best Regards,

Drago

4 Replies
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

The "Total Estimates" column should do this job
d_petrov
Contributor III
Contributor III
Author

Yes, but how? 


Total Estimates is an expression similar to the rest and therefore nothing is sorted by clicking it.

 

Best regards,

Drago

sunny_talwar

Do you happen to have disabled or conditionally hidden expressions in your chart? If you do, can you try to delete them and then try to sort it again?

d_petrov
Contributor III
Contributor III
Author

Hello,

All expressions are enabled, no conditional appearance, or something hidden.

These columns are =MAX(value) grouped by dimension ID

Any other suggestions?

Best Regards,

Drago