topic Re: Expression2 =MAX(Expression1)? in QlikView https://community.qlik.com/t5/QlikView/Expression2-MAX-Expression1/m-p/615304#M1102457 <HTML><HEAD></HEAD><BODY><P>I guess you can try using AGGR() like:</P><P></P><P>Sum(Amt) = Max(Aggr(Sum(Amt) , Dimension1, ....))</P></BODY></HTML> Tue, 08 Apr 2014 15:41:29 GMT tresB 2014-04-08T15:41:29Z Expression2 =MAX(Expression1)? https://community.qlik.com/t5/QlikView/Expression2-MAX-Expression1/m-p/615301#M1102454 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>I wanted to know if it is possible to have 2 expressions, where the 2nd expression is a MAX from the 1st expression.</P><P></P><P>Could that be possible?</P><P></P><P>Thank you!!!</P></BODY></HTML> Tue, 08 Apr 2014 15:19:29 GMT https://community.qlik.com/t5/QlikView/Expression2-MAX-Expression1/m-p/615301#M1102454 microwin88x 2014-04-08T15:19:29Z Re: Expression2 =MAX(Expression1)? https://community.qlik.com/t5/QlikView/Expression2-MAX-Expression1/m-p/615302#M1102455 <HTML><HEAD></HEAD><BODY><P>Can you share your sample data or sample apps?</P><P></P><P>You can do it like below</P><P></P><P>Expression2 = Max(TOTAL Expression1)</P></BODY></HTML> Tue, 08 Apr 2014 15:22:15 GMT https://community.qlik.com/t5/QlikView/Expression2-MAX-Expression1/m-p/615302#M1102455 MK_QSL 2014-04-08T15:22:15Z Re: Expression2 =MAX(Expression1)? https://community.qlik.com/t5/QlikView/Expression2-MAX-Expression1/m-p/615303#M1102456 <HTML><HEAD></HEAD><BODY><P>Yes may be it will write like</P><P></P><P>If( Expressssion2 = Max(Expression1, True ExecuteStatement1, False ExecuteStatement2 )</P><P></P><P>And</P><P></P><P>IF(Sum(Expression2) = Max(Expression1), Statement1,statement2) </P></BODY></HTML> Tue, 08 Apr 2014 15:27:35 GMT https://community.qlik.com/t5/QlikView/Expression2-MAX-Expression1/m-p/615303#M1102456 its_anandrjs 2014-04-08T15:27:35Z Re: Expression2 =MAX(Expression1)? https://community.qlik.com/t5/QlikView/Expression2-MAX-Expression1/m-p/615304#M1102457 <HTML><HEAD></HEAD><BODY><P>I guess you can try using AGGR() like:</P><P></P><P>Sum(Amt) = Max(Aggr(Sum(Amt) , Dimension1, ....))</P></BODY></HTML> Tue, 08 Apr 2014 15:41:29 GMT https://community.qlik.com/t5/QlikView/Expression2-MAX-Expression1/m-p/615304#M1102457 tresB 2014-04-08T15:41:29Z