Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
data_guru_001
Contributor III
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
Master
Master

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

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)