Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-09-11 01:52 AM

Expression Sorting issue

Hi,

I have been trying to sort a pivot table, which has 4 dimensions and 4 expressions.The pivot calculates total ageing and its distribution in 3 ageing buckets.

Now, i have been trying to sort the ageing based on "Location" column using below sort expression which is same as Ageing formula:


= if([AP_ Status] = 'A' and (APStatus = 'P' or  APStatus = 'Q'),

Avg(TodayDateNo - APQueryResolvedDateNo),if( [AP_ Status] = 'B' ,Avg(TodayDateNo - APQueryRaisedDateNo), Avg(TodayDateNo - UploadDateNo)))

Below is the screen shot of the pivot table. I wanted to sort the Ageing column based on Highest ageing for a "Location".

Thanks in Advance.

ExpressionSort.png

404 Views
0 Likes
0 Replies