Expression Sorting issue

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

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.

topic Expression Sorting issue in QlikView

Expression Sorting issue