topic Maximum of Multiple values over one dimension in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Maximum-of-Multiple-values-over-one-dimension/m-p/1836459#M9546 <P>Hi All, In my data source i have a table like below,</P><TABLE><TBODY><TR><TD>ID</TD><TD>Cell</TD><TD>Traffic GB</TD></TR><TR><TD>1178</TD><TD>1</TD><TD>0.0</TD></TR><TR><TD>1178</TD><TD>2</TD><TD>0.0</TD></TR><TR><TD>1178</TD><TD>3</TD><TD>0.1</TD></TR><TR><TD>1178</TD><TD>4</TD><TD>0.1</TD></TR><TR><TD>1178</TD><TD>5</TD><TD>0.5</TD></TR><TR><TD>1178</TD><TD>6</TD><TD>0.7</TD></TR><TR><TD>1178</TD><TD>7</TD><TD>0.9</TD></TR><TR><TD>1178</TD><TD>8</TD><TD>3.2</TD></TR><TR><TD>35536</TD><TD>1</TD><TD>0.0</TD></TR><TR><TD>35536</TD><TD>2</TD><TD>0.0</TD></TR><TR><TD>35536</TD><TD>3</TD><TD>0.1</TD></TR><TR><TD>35536</TD><TD>4</TD><TD>0.1</TD></TR><TR><TD>35536</TD><TD>5</TD><TD>0.1</TD></TR><TR><TD>35536</TD><TD>6</TD><TD>0.1</TD></TR><TR><TD>35536</TD><TD>7</TD><TD>0.3</TD></TR><TR><TD>35536</TD><TD>8</TD><TD>0.3</TD></TR><TR><TD>35536</TD><TD>9</TD><TD>0.3</TD></TR><TR><TD>35536</TD><TD>10</TD><TD>2.6</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><SPAN>my objective is to get the max value for each ID with its corresponding cell as shown in the table like below,</SPAN></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>ID</TD><TD>Cell</TD><TD>Traffic GB</TD></TR><TR><TD>1178</TD><TD>8</TD><TD>3.2</TD></TR><TR><TD>35536</TD><TD>10</TD><TD><P>2.6</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>any idea please&nbsp;</P> Wed, 15 Sep 2021 18:09:59 GMT EngMaher88 2021-09-15T18:09:59Z Maximum of Multiple values over one dimension https://community.qlik.com/t5/Connectivity-Data-Prep/Maximum-of-Multiple-values-over-one-dimension/m-p/1836459#M9546 <P>Hi All, In my data source i have a table like below,</P><TABLE><TBODY><TR><TD>ID</TD><TD>Cell</TD><TD>Traffic GB</TD></TR><TR><TD>1178</TD><TD>1</TD><TD>0.0</TD></TR><TR><TD>1178</TD><TD>2</TD><TD>0.0</TD></TR><TR><TD>1178</TD><TD>3</TD><TD>0.1</TD></TR><TR><TD>1178</TD><TD>4</TD><TD>0.1</TD></TR><TR><TD>1178</TD><TD>5</TD><TD>0.5</TD></TR><TR><TD>1178</TD><TD>6</TD><TD>0.7</TD></TR><TR><TD>1178</TD><TD>7</TD><TD>0.9</TD></TR><TR><TD>1178</TD><TD>8</TD><TD>3.2</TD></TR><TR><TD>35536</TD><TD>1</TD><TD>0.0</TD></TR><TR><TD>35536</TD><TD>2</TD><TD>0.0</TD></TR><TR><TD>35536</TD><TD>3</TD><TD>0.1</TD></TR><TR><TD>35536</TD><TD>4</TD><TD>0.1</TD></TR><TR><TD>35536</TD><TD>5</TD><TD>0.1</TD></TR><TR><TD>35536</TD><TD>6</TD><TD>0.1</TD></TR><TR><TD>35536</TD><TD>7</TD><TD>0.3</TD></TR><TR><TD>35536</TD><TD>8</TD><TD>0.3</TD></TR><TR><TD>35536</TD><TD>9</TD><TD>0.3</TD></TR><TR><TD>35536</TD><TD>10</TD><TD>2.6</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><SPAN>my objective is to get the max value for each ID with its corresponding cell as shown in the table like below,</SPAN></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>ID</TD><TD>Cell</TD><TD>Traffic GB</TD></TR><TR><TD>1178</TD><TD>8</TD><TD>3.2</TD></TR><TR><TD>35536</TD><TD>10</TD><TD><P>2.6</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>any idea please&nbsp;</P> Wed, 15 Sep 2021 18:09:59 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Maximum-of-Multiple-values-over-one-dimension/m-p/1836459#M9546 EngMaher88 2021-09-15T18:09:59Z Re: Maximum of Multiple values over one dimension https://community.qlik.com/t5/Connectivity-Data-Prep/Maximum-of-Multiple-values-over-one-dimension/m-p/1836469#M9547 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/149624">@EngMaher88</a>&nbsp;!</P><P>&nbsp; &nbsp; It's very easy to do.&nbsp;</P><P>Column 1: ID</P><P>Column 2: Max(Cell)<BR />Column 3: Max([Traffic GB])</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 15 Sep 2021 19:05:18 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Maximum-of-Multiple-values-over-one-dimension/m-p/1836469#M9547 joaopaulo_delco 2021-09-15T19:05:18Z