Need help about Age bucket calculation, attached clear sample data

gopal5879 — Wed, 25 Nov 2020 16:16:04 GMT

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)

Re: Need help about Age bucket calculation, attached clear sample data

sunny_talwar — Tue, 26 Dec 2017 18:00:46 GMT

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 — Wed, 27 Dec 2017 19:16:05 GMT

Thanks a lot Sunny, I am testing it now