Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amit_saini
Master III
Master III

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
Luminary Alumni
Luminary Alumni

Hi,

Try like this

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

Hope this helps you.

Regards,

Jagan.

View solution in original post

2 Replies
sunny_talwar

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

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

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

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

Hope this helps you.

Regards,

Jagan.