This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I need help with of Concat Discinct of a Field with a Sort-Weight?
The default is A-Z.
What I want is to sort by Total Absolute amount
i.e. The sort order should be as per below
But the best I can get is sorted by individual Absolute Amount – so it’s not distinct, values are repeated
it's sorted like below (not the Sum of the Amounts)
I think the answer maybe something to do with Aggr but I can’t work it out. Any ideas? See attached for sample data.
=Concat(Distinct GL_ACCOUNT_CODE_src_1,';', -Fabs(Aggr(NODISTINCT Sum(AMT_NET_TAXREP_src_1),TRANS_INVOICE_NUMBER_src_1,GL_ACCOUNT_CODE_src_1)) )
View solution in original post
Thanks - that worked! Are you able to explain what it's doing / why inparticular I need the NODISTINCT ?
Is there a way to do the same in the script?