topic Re: Max value for current and prev periods in QlikView https://community.qlik.com/t5/QlikView/Max-value-for-current-and-prev-periods/m-p/37633#M511606 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>RangeMax(Above(YourExpression), 0, RowNo()))</STRONG></P></BODY></HTML> Sun, 01 Apr 2018 15:14:02 GMT sunny_talwar 2018-04-01T15:14:02Z Max value for current and prev periods https://community.qlik.com/t5/QlikView/Max-value-for-current-and-prev-periods/m-p/37632#M511605 <HTML><HEAD></HEAD><BODY><P>I have 2 fields the first 1 in by Daily page views and the second in weekly.</P><P>I need to create a field that will hold the max value of page views for the specific Week and the previous weeks,</P><P></P><P>ATTACHED AN EXAMPLE.</P><P></P><P>(The right field is what I expect to get- Preferred to be made in layout)</P><P>Thanks</P></BODY></HTML> Sun, 01 Apr 2018 14:04:33 GMT https://community.qlik.com/t5/QlikView/Max-value-for-current-and-prev-periods/m-p/37632#M511605 Anonymous 2018-04-01T14:04:33Z Re: Max value for current and prev periods https://community.qlik.com/t5/QlikView/Max-value-for-current-and-prev-periods/m-p/37633#M511606 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>RangeMax(Above(YourExpression), 0, RowNo()))</STRONG></P></BODY></HTML> Sun, 01 Apr 2018 15:14:02 GMT https://community.qlik.com/t5/QlikView/Max-value-for-current-and-prev-periods/m-p/37633#M511606 sunny_talwar 2018-04-01T15:14:02Z Re: Max value for current and prev periods https://community.qlik.com/t5/QlikView/Max-value-for-current-and-prev-periods/m-p/37634#M511607 <HTML><HEAD></HEAD><BODY><P>WOW!!!!!!</P><P></P><P>Thanks Alot&nbsp;&nbsp; !!!!!!!!!!!!!!!</P></BODY></HTML> Sun, 01 Apr 2018 18:51:33 GMT https://community.qlik.com/t5/QlikView/Max-value-for-current-and-prev-periods/m-p/37634#M511607 Anonymous 2018-04-01T18:51:33Z Re: Max value for current and prev periods https://community.qlik.com/t5/QlikView/Max-value-for-current-and-prev-periods/m-p/37635#M511608 <HTML><HEAD></HEAD><BODY><P>Thanks it's correct!!!</P></BODY></HTML> Sun, 01 Apr 2018 18:52:22 GMT https://community.qlik.com/t5/QlikView/Max-value-for-current-and-prev-periods/m-p/37635#M511608 Anonymous 2018-04-01T18:52:22Z