topic Re: How to find min Value in QlikView

topic Re: How to find min Value in QlikView https://community.qlik.com/t5/QlikView/How-to-find-min-Value/m-p/1701914#M725948 <P>Min( total <ID> Value)</P><P>Max( total <ID> Value)</P> Thu, 14 May 2020 09:53:54 GMT tresB 2020-05-14T09:53:54Z How to find min Value https://community.qlik.com/t5/QlikView/How-to-find-min-Value/m-p/1701912#M725947 <P><EM>Hello </EM> Team,</P><P>I have data like below. Need to find out the min and max values and display to all the rows based on ID.Help me how to do this?</P><TABLE border="1" width="75%"><TBODY><TR><TD width="50%">ID</TD><TD width="25%">Value</TD></TR><TR><TD width="50%">1</TD><TD width="25%">10</TD></TR><TR><TD width="50%">1</TD><TD width="25%">2o</TD></TR><TR><TD width="50%"><SPAN>1</SPAN></TD><TD width="25%">30</TD></TR><TR><TD width="50%">2</TD><TD width="25%">40</TD></TR><TR><TD width="50%">2</TD><TD width="25%">50</TD></TR></TBODY></TABLE><P> </P><P>Output:</P><TABLE border="1" width="100%"><TBODY><TR><TD width="25%" height="25">ID</TD><TD width="25%" height="25">Value</TD><TD width="25%" height="25">Min</TD><TD width="25%" height="25">Max</TD></TR><TR><TD width="25%" height="25">1</TD><TD width="25%" height="25">10</TD><TD width="25%" height="25">10</TD><TD width="25%" height="25">30</TD></TR><TR><TD width="25%" height="25">1</TD><TD width="25%" height="25">20</TD><TD width="25%" height="25">10</TD><TD width="25%" height="25">30</TD></TR><TR><TD width="25%" height="25">1</TD><TD width="25%" height="25">30</TD><TD width="25%" height="25">10</TD><TD width="25%" height="25">30</TD></TR><TR><TD width="25%" height="25">2</TD><TD width="25%" height="25">40</TD><TD width="25%" height="25">40</TD><TD width="25%" height="25">50</TD></TR><TR><TD width="25%" height="25">2</TD><TD width="25%" height="25">50</TD><TD width="25%" height="25">40</TD><TD width="25%" height="25">50</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 00:40:50 GMT https://community.qlik.com/t5/QlikView/How-to-find-min-Value/m-p/1701912#M725947 gireesh1216 2024-11-16T00:40:50Z Re: How to find min Value https://community.qlik.com/t5/QlikView/How-to-find-min-Value/m-p/1701914#M725948 <P>Min( total <ID> Value)</P><P>Max( total <ID> Value)</P> Thu, 14 May 2020 09:53:54 GMT https://community.qlik.com/t5/QlikView/How-to-find-min-Value/m-p/1701914#M725948 tresB 2020-05-14T09:53:54Z