Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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]