Sorting Pivot Table

[Anonymous]

Dear Qlik Community,

I want to sort my Pivot Table by "Total delayed PO lines >1 w".

I'm sorting Vendor nr by the expression I used to calculate ""Total delayed PO lines >1 w".

Count( {$<[Performance detailed]={'e. Overdue 1m','f. Overdue >1m'}>} [Vendor nr] )

Unfortunately that doesn't seem to do the trick. What am I missing here?

See attachment for print screen.

[avkeep01]

Hi, 

I was trying to fix your sorting issue. Got some troubles, so went on building the expression as suggested. Still no correct result though. This is the expression I used in the script. 

IF(MATCH([Performance detailed],'e. Overdue 1m','f. Overdue >1m')>0,1) AS [Total delayed PO lines >1 w]