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 @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])
Hi @agigliotti,
I did as you told but no succes.
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 @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.
@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?