Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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)