Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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