Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
norbertm
Contributor
Contributor

Aggregate a Dimension

I was trying to build an simple application where i'm trying to build a simple application where I want to aggregate the  dimension on a Max TimeStamp

Ticket_Name_TotalDescription_TotalTicket_CB_TotalDefect_Number_TotalLD_Name_TotalBS_Name_TotalTimeStamp_Total
My First TicketLorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.CB-0001DEF-0003John DoeJane Doe4/23/2020 10:05:12 PM
My Second TicketLorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.CB-0002DEF-0004John DoeJane Doe4/23/2020 9:59:56 PM
My Second TicketLorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.CB-0002DEF-0003John DoeJane Doe4/23/2020 9:59:44 PM
My Second TicketLorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.CB-0002DEF-0002John DoeJane Doe4/23/2020 9:59:33 PM
My Second TicketLorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.CB-0002DEF-0001John DoeJane Doe4/23/2020 9:59:21 PM
My First TicketLorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.CB-0001DEF-0002John DoeJane Doe4/23/2020 9:59:00 PM
My First TicketLorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.CB-0001DEF-0001John DoeJane Doe4/23/2020 9:58:41 PM
My Second TicketLorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.CB-0002 John DoeJane Doe4/23/2020 9:57:56 PM
My First TicketLorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing.CB-0001 John DoeJane Doe4/23/2020 9:56:33 PM

 

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.

Hopefully someone can help me 

Labels (2)
0 Replies