Need some help, I have attached the dataset. May be Aggr function

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

Hi Guys need some help since I am new to Qlikview. I have attached the details as below .

Finally I need the output highlighted in orange in Pie Chart.

Essentially I need help to get the max QueueAge records highlighted in Yellow to Transformed records in Green and then created Pie Chart with data highlighted in orange. Just struggling to put it together, Can some one help me

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 some help, I have attached the dataset. May be Aggr function

sunny_talwar — Tue, 26 Dec 2017 18:04:26 GMT

Try not to create the same issue multiple times... check here: Need help about Age bucket calculation, attached clear sample data

Re: Need some help, I have attached the dataset. May be Aggr function

gopal5879 — Fri, 12 Jan 2018 01:45:36 GMT

Thanks Sunny for your help

topic Re: Need some help, I have attached the dataset. May be Aggr function in QlikView

Need some help, I have attached the dataset. May be Aggr function

Re: Need some help, I have attached the dataset. May be Aggr function

Re: Need some help, I have attached the dataset. May be Aggr function