topic Re: Max is not working in QlikView https://community.qlik.com/t5/QlikView/Max-is-not-working/m-p/73952#M784837 <HTML><HEAD></HEAD><BODY><P>kpi object also same number it is displaying</P></BODY></HTML> Thu, 08 Mar 2018 14:51:14 GMT soniasweety 2018-03-08T14:51:14Z Max is not working https://community.qlik.com/t5/QlikView/Max-is-not-working/m-p/73946#M784824 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have&nbsp; monthno field </P><P></P><P>so I have data till feb&nbsp;&nbsp;&nbsp; but feb data is showing zero</P><P></P><P>till jan it worked.</P><P></P><P>sum({&lt;MonthNo={$(=Max(MonthNo))},CB={'st','OS'}&gt;}[Amount])</P><P></P><P></P><P>so is there any other way to get it?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Max-is-not-working/m-p/73946#M784824 soniasweety 2020-11-25T16:16:04Z Re: Max is not working https://community.qlik.com/t5/QlikView/Max-is-not-working/m-p/73947#M784827 <HTML><HEAD></HEAD><BODY><P>MonthNo is a numeric field or text field or date field?</P></BODY></HTML> Thu, 08 Mar 2018 14:28:34 GMT https://community.qlik.com/t5/QlikView/Max-is-not-working/m-p/73947#M784827 sunny_talwar 2018-03-08T14:28:34Z Re: Max is not working https://community.qlik.com/t5/QlikView/Max-is-not-working/m-p/73948#M784830 <HTML><HEAD></HEAD><BODY><P><IMG alt="num.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195719_num.PNG" style="height: auto;" /></P><P>Numeric only</P></BODY></HTML> Thu, 08 Mar 2018 14:33:54 GMT https://community.qlik.com/t5/QlikView/Max-is-not-working/m-p/73948#M784830 soniasweety 2018-03-08T14:33:54Z Re: Max is not working https://community.qlik.com/t5/QlikView/Max-is-not-working/m-p/73949#M784833 <HTML><HEAD></HEAD><BODY><P>Is this a filter box you have posted an image of? The reason I ask is because the number 43132 keep on repeating... which makes me think if MonthNo has a decimals in it?</P></BODY></HTML> Thu, 08 Mar 2018 14:41:25 GMT https://community.qlik.com/t5/QlikView/Max-is-not-working/m-p/73949#M784833 sunny_talwar 2018-03-08T14:41:25Z Re: Max is not working https://community.qlik.com/t5/QlikView/Max-is-not-working/m-p/73950#M784835 <HTML><HEAD></HEAD><BODY><P>no its single only.</P><P></P><P>because I have one more dimesion added in the table. so its showing for all values.</P></BODY></HTML> Thu, 08 Mar 2018 14:43:42 GMT https://community.qlik.com/t5/QlikView/Max-is-not-working/m-p/73950#M784835 soniasweety 2018-03-08T14:43:42Z Re: Max is not working https://community.qlik.com/t5/QlikView/Max-is-not-working/m-p/73951#M784836 <HTML><HEAD></HEAD><BODY><P>Can you check what do you get in a KPI object when you use this</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=Max(MonthNo)</STRONG></SPAN></P></BODY></HTML> Thu, 08 Mar 2018 14:45:06 GMT https://community.qlik.com/t5/QlikView/Max-is-not-working/m-p/73951#M784836 sunny_talwar 2018-03-08T14:45:06Z Re: Max is not working https://community.qlik.com/t5/QlikView/Max-is-not-working/m-p/73952#M784837 <HTML><HEAD></HEAD><BODY><P>kpi object also same number it is displaying</P></BODY></HTML> Thu, 08 Mar 2018 14:51:14 GMT https://community.qlik.com/t5/QlikView/Max-is-not-working/m-p/73952#M784837 soniasweety 2018-03-08T14:51:14Z Re: Max is not working https://community.qlik.com/t5/QlikView/Max-is-not-working/m-p/73953#M784838 <HTML><HEAD></HEAD><BODY><P>This might sound stupid... but do you have Amount for Feb?</P></BODY></HTML> Thu, 08 Mar 2018 14:52:15 GMT https://community.qlik.com/t5/QlikView/Max-is-not-working/m-p/73953#M784838 sunny_talwar 2018-03-08T14:52:15Z