topic Max value help in QlikView

Max value help

amit_saini — Tue, 07 Jul 2015 10:25:41 GMT

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

sunny_talwar — Tue, 07 Jul 2015 10:28:49 GMT

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

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

jagan — Tue, 07 Jul 2015 10:42:30 GMT

Hi,

Try like this

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

Hope this helps you.

Regards,

Jagan.