Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Partitioning data in script

I am doing an app on trades. There are multiple commission rates for one trade amount (creating lots of extra data). I am trying to use a function in the script to take the highest commission rate only for each trade. Max function maybe????

-Kevin

1 Reply
mov
Esteemed Contributor III

Re: Partitioning data in script

Hi Kevin,

Max() makes sense, for example:

SELECT

max(CommisionRate) as HighestRate,

TradeID

FROM  Trades

GROUP BY TradeID;

Regards,

Michael

Community Browser