topic Re: Day with maximum value in QlikView https://community.qlik.com/t5/QlikView/Day-with-maximum-value/m-p/1334278#M411802 <HTML><HEAD></HEAD><BODY><P><EM>Share the sample app with the required output so that it will help us to understand </EM></P></BODY></HTML> Thu, 25 May 2017 06:29:04 GMT avinashelite 2017-05-25T06:29:04Z Day with maximum value https://community.qlik.com/t5/QlikView/Day-with-maximum-value/m-p/1334274#M411798 <HTML><HEAD></HEAD><BODY><P>I would like to show table where it will one (the highest value)and its date within each month.</P><P></P><P>The problem is that I calculate aggr function on month year level, but when I would like to show maximum date within month which is lower level than month year it will fail. </P><P></P><P>The other task is not to show other dates where maximum value isn't.</P><P></P><P>In the printscreen below you can see within pivot table I am able to do it this way but I am unable to hide those non maximum dates..</P></BODY></HTML> Wed, 24 May 2017 20:12:23 GMT https://community.qlik.com/t5/QlikView/Day-with-maximum-value/m-p/1334274#M411798 michal_durica 2017-05-24T20:12:23Z Re: Day with maximum value https://community.qlik.com/t5/QlikView/Day-with-maximum-value/m-p/1334275#M411799 <HTML><HEAD></HEAD><BODY><P>Can you send a sample app, but I am sure you can do it by hiding nulls and zero values.</P></BODY></HTML> Wed, 24 May 2017 22:00:13 GMT https://community.qlik.com/t5/QlikView/Day-with-maximum-value/m-p/1334275#M411799 sibusiso90 2017-05-24T22:00:13Z Re: Day with maximum value https://community.qlik.com/t5/QlikView/Day-with-maximum-value/m-p/1334276#M411800 <HTML><HEAD></HEAD><BODY><P>You have values in the other two expressions, Exposure low and settlement, do you want to hide those values as well?</P></BODY></HTML> Wed, 24 May 2017 22:47:47 GMT https://community.qlik.com/t5/QlikView/Day-with-maximum-value/m-p/1334276#M411800 Digvijay_Singh 2017-05-24T22:47:47Z Re: Day with maximum value https://community.qlik.com/t5/QlikView/Day-with-maximum-value/m-p/1334277#M411801 <HTML><HEAD></HEAD><BODY><P>please post a sample app</P></BODY></HTML> Thu, 25 May 2017 06:27:13 GMT https://community.qlik.com/t5/QlikView/Day-with-maximum-value/m-p/1334277#M411801 vinieme12 2017-05-25T06:27:13Z Re: Day with maximum value https://community.qlik.com/t5/QlikView/Day-with-maximum-value/m-p/1334278#M411802 <HTML><HEAD></HEAD><BODY><P><EM>Share the sample app with the required output so that it will help us to understand </EM></P></BODY></HTML> Thu, 25 May 2017 06:29:04 GMT https://community.qlik.com/t5/QlikView/Day-with-maximum-value/m-p/1334278#M411802 avinashelite 2017-05-25T06:29:04Z Re: Day with maximum value https://community.qlik.com/t5/QlikView/Day-with-maximum-value/m-p/1334279#M411803 <HTML><HEAD></HEAD><BODY><P>I already fixed it: by combination of function rank and aggr</P><P>if(aggr(rank(calculation),Month_Year,Datum)</P></BODY></HTML> Thu, 25 May 2017 07:10:52 GMT https://community.qlik.com/t5/QlikView/Day-with-maximum-value/m-p/1334279#M411803 michal_durica 2017-05-25T07:10:52Z Re: Day with maximum value https://community.qlik.com/t5/QlikView/Day-with-maximum-value/m-p/1334280#M411804 <HTML><HEAD></HEAD><BODY><P>if(aggr(rank(Calculation),Month_Year,Date)&lt;=1,Calculation)</P></BODY></HTML> Thu, 25 May 2017 07:11:57 GMT https://community.qlik.com/t5/QlikView/Day-with-maximum-value/m-p/1334280#M411804 michal_durica 2017-05-25T07:11:57Z