topic Re: Sorting Expression when Conditional? in QlikView

Sorting Expression when Conditional?

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

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!

Re: Sorting Expression when Conditional?

shiveshsingh — Sat, 18 Aug 2018 03:40:08 GMT

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

Re: Sorting Expression when Conditional?

BalaBhaskar_Qlik — Sat, 18 Aug 2018 11:19:19 GMT

May be try like this:

Sort - Expression - descending

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

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

Re: Sorting Expression when Conditional?

Anil_Babu_Samineni — Sat, 18 Aug 2018 13:43:12 GMT

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