Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
data_guru_001
New Contributor III

Sorting Expression when Conditional?

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!

3 Replies
shiveshsingh
Honored Contributor

Re: Sorting Expression when Conditional?

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

balabhaskarqlik
Honored Contributor

Re: Sorting Expression when Conditional?

May be try like this:

Sort - Expression - descending

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

Or

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

Re: Sorting Expression when Conditional?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)