I am trying to create a pie chart from an Oracle table with Qlik sense desktop. My table structure is table1(countries, sale, income)
I use ‘countries’ column as a filter, and the pie chart will show total ‘sale’ and ‘income’ when I select different country or countries.
How could I get the above pie chart with Qlik Sense?
Figure out a walking around solution: change the table structure
countries, sale, income
We will get a new table with only two columns instead of the original three columns table, and we can use Qlik Pie chart object with countries as dimension and the second column as measure.