topic Sorting in straight table based on dimension value in QlikView

Sorting in straight table based on dimension value

ashis — Sat, 16 Nov 2024 03:29:58 GMT

Hello,

I have a straight table and it has more around 30 columns , all are dimensions. There is no expression.

In dimension , we have date , daily, monthly , yearly .... and many more columns.

I want to sort desc based on these daily, monthly and yearly values using there absolute value.

So in the sort tab i use

daily in first place and in expression putting =FABS(SUM(daily))

monthly in 2nd place in the expression =FABS(SUM(monthly))

yearly in 3rd place in the expression =FABS(SUM(yearly))

Will it work ?

i see for some selection where there is no 0 value for daily and monthly , yearly column is not sorting dese wise.

Please advise.

sunny_talwar — Thu, 23 May 2019 12:15:24 GMT

Might be easy to help if you are able to share a sample

ashis — Fri, 24 May 2019 03:09:53 GMT

Hi Sunny,

Due to restriction unable to share qvw file.

Just wanted to know , if i want to sort more than one columns( that are dimensions), is that the way to do it logically.