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) | | | |
