topic how to use max function as below please help me on this in QlikView https://community.qlik.com/t5/QlikView/how-to-use-max-function-as-below-please-help-me-on-this/m-p/1251477#M396006 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I need the expression like below how to get ,Can you please give me solution for this.</P><P></P><P>Max(expression1 something like sales]/(Budget expression)-(discount expression))</P><P></P><P>Max((exp1)/(exp2))</P><P></P><P>i have to do the variance of 2 expression and i want to get the max values of it.</P><P>How do i achieve this.</P><P></P><P>Regards</P><P>Sonysree</P></BODY></HTML> Tue, 21 Mar 2017 12:39:57 GMT sonysree88 2017-03-21T12:39:57Z how to use max function as below please help me on this https://community.qlik.com/t5/QlikView/how-to-use-max-function-as-below-please-help-me-on-this/m-p/1251477#M396006 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I need the expression like below how to get ,Can you please give me solution for this.</P><P></P><P>Max(expression1 something like sales]/(Budget expression)-(discount expression))</P><P></P><P>Max((exp1)/(exp2))</P><P></P><P>i have to do the variance of 2 expression and i want to get the max values of it.</P><P>How do i achieve this.</P><P></P><P>Regards</P><P>Sonysree</P></BODY></HTML> Tue, 21 Mar 2017 12:39:57 GMT https://community.qlik.com/t5/QlikView/how-to-use-max-function-as-below-please-help-me-on-this/m-p/1251477#M396006 sonysree88 2017-03-21T12:39:57Z Re: how to use max function as below please help me on this https://community.qlik.com/t5/QlikView/how-to-use-max-function-as-below-please-help-me-on-this/m-p/1251478#M396007 <HTML><HEAD></HEAD><BODY><P>If your expressions are aggregations, you would need advanced aggregation and a grouping entitiy (dimension(s) <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><P></P><P>Something like</P><P></P><P>=Max( Aggr( Sum(Sales) / Sum(Budget), Customer))</P></BODY></HTML> Tue, 21 Mar 2017 12:42:38 GMT https://community.qlik.com/t5/QlikView/how-to-use-max-function-as-below-please-help-me-on-this/m-p/1251478#M396007 swuehl 2017-03-21T12:42:38Z