Discussion Board for collaboration related to QlikView App Development.
I am trying to find out the value of "Make" field which has highest "Invoice" value for each "Type".
I have achieved it in the backend, but to make it more dynamic based on front end selection, I need to calculate it at UI level.
Example of Source Data: (NOTE: Full excel file for the same is attached)
Target Output for above partial data:
Thanks in advance for the help.
View solution in original post
FirstSortedValue( Type, -Invoce)
Apart from this, is there any way we can achieve the same using Nested aggregation with MAX() and AGGR().
You solution is quite simple and awesome. I am just trying to expand my knowledge on use of AGGR() function too.
Thanks again for the help and look forward to your reply.
Sure thing... try this
=Concat(Aggr(If(Max(TOTAL <Type> Invoice) = Invoice, Make), Type, Make, Invoice))
Thanks a lot GURU.