Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to sort items based on spend and i need figures based on savings in the pie-chart

How to sort items based on spend and i need figures based on savings in the pie-chart.I want to sort only top 3 items and  this is my table


 

Item ID SpendSavings
1112012
1214014
139040
143016
1518018
166030
1711017
18408
1913025
2016010

So pie-chart answer should be like this                                          and NOT like this

Item ID      Savings                                                                 Item ID      Savings

15                18                                                                          13             40

20                10                                                                          16             30

12                14                                                                          19             25

Thanks in advance

Regards

Nagarjuna

31 Replies
sunny_talwar

I am confused now. What all have you accomplished and what all are you looking to get help with? Can you provide a Excel example instead of attaching images?

Not applicable
Author

I got the solution, anyway thanks.