https://community.qlik.com/t5/App-Development/Aggregate-a-Dimension/m-p/1696283#M53261 <P>I was trying to build an simple application where i'm trying to build a simple application where I want to aggregate the&nbsp; dimension on a Max TimeStamp</P><TABLE width="1438"><TBODY><TR><TD width="140.8px" height="24px"><STRONG>Ticket_Name_Total</STRONG></TD><TD width="412.8px" height="24px"><STRONG>Description_Total</STRONG></TD><TD width="119.2px" height="24px"><STRONG>Ticket_CB_Total</STRONG></TD><TD width="157.6px" height="24px"><STRONG>Defect_Number_Total</STRONG></TD><TD width="208.8px" height="24px"><STRONG>LD_Name_Total</STRONG></TD><TD width="247.2px" height="24px"><STRONG>BS_Name_Total</STRONG></TD><TD width="150.4px" height="24px"><STRONG>TimeStamp_Total</STRONG></TD></TR><TR><TD width="140.8px" height="45px">My First Ticket</TD><TD width="412.8px" height="45px">Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.</TD><TD width="119.2px" height="45px">CB-0001</TD><TD width="157.6px" height="45px">DEF-0003</TD><TD width="208.8px" height="45px">John Doe</TD><TD width="247.2px" height="45px">Jane Doe</TD><TD width="150.4px" height="45px">4/23/2020 10:05:12 PM</TD></TR><TR><TD width="140.8px" height="45px">My Second Ticket</TD><TD width="412.8px" height="45px">Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.</TD><TD width="119.2px" height="45px">CB-0002</TD><TD width="157.6px" height="45px">DEF-0004</TD><TD width="208.8px" height="45px">John Doe</TD><TD width="247.2px" height="45px">Jane Doe</TD><TD width="150.4px" height="45px">4/23/2020 9:59:56 PM</TD></TR><TR><TD width="140.8px" height="45px">My Second Ticket</TD><TD width="412.8px" height="45px">Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.</TD><TD width="119.2px" height="45px">CB-0002</TD><TD width="157.6px" height="45px">DEF-0003</TD><TD width="208.8px" height="45px">John Doe</TD><TD width="247.2px" height="45px">Jane Doe</TD><TD width="150.4px" height="45px">4/23/2020 9:59:44 PM</TD></TR><TR><TD width="140.8px" height="45px">My Second Ticket</TD><TD width="412.8px" height="45px">Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.</TD><TD width="119.2px" height="45px">CB-0002</TD><TD width="157.6px" height="45px">DEF-0002</TD><TD width="208.8px" height="45px">John Doe</TD><TD width="247.2px" height="45px">Jane Doe</TD><TD width="150.4px" height="45px">4/23/2020 9:59:33 PM</TD></TR><TR><TD width="140.8px" height="45px">My Second Ticket</TD><TD width="412.8px" height="45px">Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.</TD><TD width="119.2px" height="45px">CB-0002</TD><TD width="157.6px" height="45px">DEF-0001</TD><TD width="208.8px" height="45px">John Doe</TD><TD width="247.2px" height="45px">Jane Doe</TD><TD width="150.4px" height="45px">4/23/2020 9:59:21 PM</TD></TR><TR><TD width="140.8px" height="45px">My First Ticket</TD><TD width="412.8px" height="45px">Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.</TD><TD width="119.2px" height="45px">CB-0001</TD><TD width="157.6px" height="45px">DEF-0002</TD><TD width="208.8px" height="45px">John Doe</TD><TD width="247.2px" height="45px">Jane Doe</TD><TD width="150.4px" height="45px">4/23/2020 9:59:00 PM</TD></TR><TR><TD width="140.8px" height="45px">My First Ticket</TD><TD width="412.8px" height="45px">Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.</TD><TD width="119.2px" height="45px">CB-0001</TD><TD width="157.6px" height="45px">DEF-0001</TD><TD width="208.8px" height="45px">John Doe</TD><TD width="247.2px" height="45px">Jane Doe</TD><TD width="150.4px" height="45px">4/23/2020 9:58:41 PM</TD></TR><TR><TD width="140.8px" height="45px">My Second Ticket</TD><TD width="412.8px" height="45px">Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.</TD><TD width="119.2px" height="45px">CB-0002</TD><TD width="157.6px" height="45px">&nbsp;</TD><TD width="208.8px" height="45px">John Doe</TD><TD width="247.2px" height="45px">Jane Doe</TD><TD width="150.4px" height="45px">4/23/2020 9:57:56 PM</TD></TR><TR><TD width="140.8px" height="45px">My First Ticket</TD><TD width="412.8px" height="45px">Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.</TD><TD width="119.2px" height="45px">CB-0001</TD><TD width="157.6px" height="45px">&nbsp;</TD><TD width="208.8px" height="45px">John Doe</TD><TD width="247.2px" height="45px">Jane Doe</TD><TD width="150.4px" height="45px">4/23/2020 9:56:33 PM</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>As result I'm looking for an aggregation that show the latest dimension based on the timestamps and unique Ticket_CB and place this in calculated text field.</P><P>Hopefully someone can help me&nbsp;</P> Sat, 16 Nov 2024 02:36:16 GMT norbertm 2024-11-16T02:36:16Z https://community.qlik.com/t5/App-Development/Aggregate-a-Dimension/m-p/1696283#M53261 <P>I was trying to build an simple application where i'm trying to build a simple application where I want to aggregate the&nbsp; dimension on a Max TimeStamp</P><TABLE width="1438"><TBODY><TR><TD width="140.8px" height="24px"><STRONG>Ticket_Name_Total</STRONG></TD><TD width="412.8px" height="24px"><STRONG>Description_Total</STRONG></TD><TD width="119.2px" height="24px"><STRONG>Ticket_CB_Total</STRONG></TD><TD width="157.6px" height="24px"><STRONG>Defect_Number_Total</STRONG></TD><TD width="208.8px" height="24px"><STRONG>LD_Name_Total</STRONG></TD><TD width="247.2px" height="24px"><STRONG>BS_Name_Total</STRONG></TD><TD width="150.4px" height="24px"><STRONG>TimeStamp_Total</STRONG></TD></TR><TR><TD width="140.8px" height="45px">My First Ticket</TD><TD width="412.8px" height="45px">Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.</TD><TD width="119.2px" height="45px">CB-0001</TD><TD width="157.6px" height="45px">DEF-0003</TD><TD width="208.8px" height="45px">John Doe</TD><TD width="247.2px" height="45px">Jane Doe</TD><TD width="150.4px" height="45px">4/23/2020 10:05:12 PM</TD></TR><TR><TD width="140.8px" height="45px">My Second Ticket</TD><TD width="412.8px" height="45px">Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.</TD><TD width="119.2px" height="45px">CB-0002</TD><TD width="157.6px" height="45px">DEF-0004</TD><TD width="208.8px" height="45px">John Doe</TD><TD width="247.2px" height="45px">Jane Doe</TD><TD width="150.4px" height="45px">4/23/2020 9:59:56 PM</TD></TR><TR><TD width="140.8px" height="45px">My Second Ticket</TD><TD width="412.8px" height="45px">Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.</TD><TD width="119.2px" height="45px">CB-0002</TD><TD width="157.6px" height="45px">DEF-0003</TD><TD width="208.8px" height="45px">John Doe</TD><TD width="247.2px" height="45px">Jane Doe</TD><TD width="150.4px" height="45px">4/23/2020 9:59:44 PM</TD></TR><TR><TD width="140.8px" height="45px">My Second Ticket</TD><TD width="412.8px" height="45px">Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.</TD><TD width="119.2px" height="45px">CB-0002</TD><TD width="157.6px" height="45px">DEF-0002</TD><TD width="208.8px" height="45px">John Doe</TD><TD width="247.2px" height="45px">Jane Doe</TD><TD width="150.4px" height="45px">4/23/2020 9:59:33 PM</TD></TR><TR><TD width="140.8px" height="45px">My Second Ticket</TD><TD width="412.8px" height="45px">Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.</TD><TD width="119.2px" height="45px">CB-0002</TD><TD width="157.6px" height="45px">DEF-0001</TD><TD width="208.8px" height="45px">John Doe</TD><TD width="247.2px" height="45px">Jane Doe</TD><TD width="150.4px" height="45px">4/23/2020 9:59:21 PM</TD></TR><TR><TD width="140.8px" height="45px">My First Ticket</TD><TD width="412.8px" height="45px">Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.</TD><TD width="119.2px" height="45px">CB-0001</TD><TD width="157.6px" height="45px">DEF-0002</TD><TD width="208.8px" height="45px">John Doe</TD><TD width="247.2px" height="45px">Jane Doe</TD><TD width="150.4px" height="45px">4/23/2020 9:59:00 PM</TD></TR><TR><TD width="140.8px" height="45px">My First Ticket</TD><TD width="412.8px" height="45px">Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.</TD><TD width="119.2px" height="45px">CB-0001</TD><TD width="157.6px" height="45px">DEF-0001</TD><TD width="208.8px" height="45px">John Doe</TD><TD width="247.2px" height="45px">Jane Doe</TD><TD width="150.4px" height="45px">4/23/2020 9:58:41 PM</TD></TR><TR><TD width="140.8px" height="45px">My Second Ticket</TD><TD width="412.8px" height="45px">Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.</TD><TD width="119.2px" height="45px">CB-0002</TD><TD width="157.6px" height="45px">&nbsp;</TD><TD width="208.8px" height="45px">John Doe</TD><TD width="247.2px" height="45px">Jane Doe</TD><TD width="150.4px" height="45px">4/23/2020 9:57:56 PM</TD></TR><TR><TD width="140.8px" height="45px">My First Ticket</TD><TD width="412.8px" height="45px">Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.</TD><TD width="119.2px" height="45px">CB-0001</TD><TD width="157.6px" height="45px">&nbsp;</TD><TD width="208.8px" height="45px">John Doe</TD><TD width="247.2px" height="45px">Jane Doe</TD><TD width="150.4px" height="45px">4/23/2020 9:56:33 PM</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>As result I'm looking for an aggregation that show the latest dimension based on the timestamps and unique Ticket_CB and place this in calculated text field.</P><P>Hopefully someone can help me&nbsp;</P> Sat, 16 Nov 2024 02:36:16 GMT https://community.qlik.com/t5/App-Development/Aggregate-a-Dimension/m-p/1696283#M53261 norbertm 2024-11-16T02:36:16Z