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.

[agigliotti]

let's try to apply the same order by expression also for "Category descr" dimension.

[avkeep01]

Hi @Anonymous, 

You could try to aggregate over the caterogy dimensions, so it sorts the vendors within the category. 

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

[Anonymous]

Hi @avkeep01,

Thx for your reply.

I tried it but no succes.

[Anonymous]

Hi @agigliotti,

I did as you told but no succes.

[agigliotti]

be sure to untick "Sort numerically" and "Sort alphabetically" options under Sort by expression.
it should works.

[avkeep01]

Hi Tom, 

recreated your example and sorting by expression worked fine.

Sum([Total delayed PO lines])

The thing is that I didn't use the part from the set analysis. Mabye you could bring that part to the script and created the same field as I mentioned. 

[agigliotti]

or try the below expression:
Aggr( Count( {$<[Performance detailed]={'e. Overdue 1m','f. Overdue >1m'}>} [Vendor nr] ) [Category desc], [Vendor nr] )

[Anonymous]

Hi @agigliotti & @avkeep01,

Still no luck. For convenience I created and attached a sample qvf.file.

As I was not able to upload it via the forum due to error "The contents of the attachment doesn't match its file type." I uploaded it to WeTransfer.

https://we.tl/t-nERN0FTTru

[Anonymous]

---

@avkeep01 wrote:

Hi Tom, 

recreated your example and sorting by expression worked fine.

Sum([Total delayed PO lines])

The thing is that I didn't use the part from the set analysis. Mabye you could bring that part to the script and created the same field as I mentioned. 

---

Hi @avkeep01,

I tried bringing my expression to the load script but ran into an error. Could you have a look?