Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Maximum value

Hi Guys:

I am struggling with a problem, will appreciate your help

I have a straight table which looks like . E = V1 + V2,  ER = E * 2

Months   Category    V1  V2  E  ER

Jan      A                10  20   30   60

Feb     A                 20 5     25   50

Mar    B                  30  4   34    68

April   C                  3   4    7      14

from this table , i need to get the Category which has maximum ER. then i need to plot both OE and OR on a line graph over months

I am not getting how to calculate max ER

0 Replies