topic Straight table sorting numbers in expressions by clicking the header in QlikView

Straight table sorting numbers in expressions by clicking the header

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

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

Re: Straight table sorting numbers in expressions by clicking the header

MindaugasBacius — Fri, 01 Feb 2019 10:01:30 GMT

The "Total Estimates" column should do this job

Re: Straight table sorting numbers in expressions by clicking the header

d_petrov — Fri, 01 Feb 2019 10:54:52 GMT

Yes, but how?

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

Best regards,

Drago

Re: Straight table sorting numbers in expressions by clicking the header

sunny_talwar — Fri, 01 Feb 2019 12:48:23 GMT

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?

Re: Straight table sorting numbers in expressions by clicking the header

d_petrov — Fri, 01 Feb 2019 14:54:55 GMT

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