Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Using maxString in Set Analysis

Hello,

I am trying to get this expression to work:

='Total: ' & num(sum({$<[Opp Created Year] = maxString([Opp Created Year])>} [Line Total Price - USD]),'$##,###.')

but it says error in set modifier element function name. I want to get the sum of line total price - usd of the current max opp created year.

Thanks!

-Jason

1 Reply
MVP
MVP

Re: Using maxString in Set Analysis

Hi,

Try this

='Total: ' & num(sum({$<[Opp Created Year] = {'$(=MaxString([Opp Created Year]))'}>} [Line Total Price - USD]),'$##,###.')


Hope this helps you.


Regards,

Jagan.

Community Browser