Need help about Age bucket calculation, attached clear sample data

[gopal5879]

How can I transform the data into data highlighted in Orange and create pie chart or chart that makes meaningful

Appreciate your help

Original QlikView DataSet available in QLiKVIEW
Queue	APPID	DATE	QUEUEAGE	AgeBucket
Q1	1000	10/1/2017	1	1 day
Q1	1000	10/2/2017	2	2 day
Q1	1000	10/3/2017	3	3 days
Q1	1000	10/4/2017	4	4 or plus
Q1	1000	10/5/2017	5	4 or plus	max Queue Age record For this Queue and APPID
Q2	1000	10/1/2017	1	1 day
Q2	1000	10/2/2017	2	2 day
Q2	1000	10/3/2017	3	3 days
Q2	1000	10/4/2017	4	4 or plus
Q2	1000	10/5/2017	5	4 or plus	max Queue Age record For this Queue and APPID
Queue	APPID	DATE	QUEUEAGE	AgeBucket
Q3	1000	10/1/2017	1	1 day
Q3	1000	10/2/2017	2	2 day	max Queue Age record For this Queue and APPID
Final Output Selection Needed
Q1	1000	10/5/2017	5	4 or plus	max Queue Age record For this Queue and APPID
Q2	1000	10/5/2017	5	4 or plus	max Queue Age record For this Queue and APPID
Q3	1000	10/2/2017	2	2 day	max Queue Age record For this Queue and APPID
Final Age Bucket  Needs as below  for Pie Chart
Age Bucket	Count
4 or plus	2	Distinct of ( Q1, 1000), (Q2 ,1000)
2 Day	1	Distinct of ( Q3, 1000)

[sunny_talwar]

This?

Straight table on the top

Dimension

Queue

APPID

Expressions

=Date(FirstSortedValue(DATE, -QUEUEAGE))

=Max(QUEUEAGE)

=FirstSortedValue(AgeBucket, -QUEUEAGE)

Pie chart at the bottom

Dimension

=Aggr(FirstSortedValue(AgeBucket, -QUEUEAGE), Queue, APPID)

Expression

=Count(DISTINCT APPID&Queue)

[gopal5879]

Thanks a lot Sunny, I am testing it now