Discussion board where members can get started with Qlik Sense.
I just wanted to create a pie chart like excel.
My table is as below:
Count(Apple) | Count(Orange) | Count(Banana)
3| 4| 5
I pulled the pie chart and drop my fields "Apple", "Orange" and "Banana" and add the measure to count but the pie chart will not plot without a dimension. What do I put as a dimension?
If I want to show the pie chart as percentage over total, how do I do it?
You can 'unpivot' these columns and use the unpivoted column names as your dimension in the data manager.
I don't understand the solution. Which fields do I drag and drop as dimention and where can I "unpivot"?
This may help:
Unpivoting crosstab data in the data manager.
You'd be using "Apple", "Orange" and "Banana" as the columns to unpivot, and then your measure will be assigned to each category, i.e. "Apple", "Orange" and "Banana" in a single column vs a measure in each.