Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

amit_saini
Not applicable

Max value help

Hi Folks,

Based on max KPI value need to have corresponding value in UKURS . See below

Requirements : Total Cost:  Sum(Sales) * UKURS value corresponding to max KPI field.

Based on selections below , I'm having 4.0394 as value corresponding to Max KPI value . so this value I need multiply in Total cost cal.

Thanks,
AS

1 Solution

Accepted Solutions
jagan
Not applicable

Re: Max value help

Hi,

Try like this

=Sum(Sales) * Only({<KPI={$(=Max(KPI))}>} UKURS)

Hope this helps you.

Regards,

Jagan.

2 Replies
sunny_talwar
Not applicable

Re: Max value help

Not sure if I understand completely, but may be this:

=Sum(Sales) * Only({<KPI = {"$(=Max(99999999 - GDATU))"}>}UKURS)

jagan
Not applicable

Re: Max value help

Hi,

Try like this

=Sum(Sales) * Only({<KPI={$(=Max(KPI))}>} UKURS)

Hope this helps you.

Regards,

Jagan.