Sorting Expression when Conditional?

[data_guru_001]

Hi,

I am running into an issue with a straight table I've created. I am unable to sort the data in my expression column from least to greatest/greatest to least.

Normally, I've never run into this issue, but for my expression in this straight table, I do have a conditional. The only thing I can think of, is that Qlik won't allow you to sort on the column's data, when there is a conditional applied? I had done some research on this through other posts, and they looked to confirm this, but were at least 3-4 years old.

Can anyone tell me if this is in fact my most likely problem, and if so any workarounds?

Thanks!

[shiveshsingh]

which expression you are using in sort? you can also sort your data by expression.

[balabhaskarqlik]

May be try like this:

Sort - Expression - descending

=Min(RangeSum(Date,Alt(StartTime,0.99999)))

Or

=Min(TOTAL Aggr(StartTime,Date,Account))

[Anil_Babu_Samineni]

I never come across sort problem using Conditional. But, There might be other work around. Can you show where you are we can think better