Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Qliksense: How to create a pie chart without dimenion? Just 3 values.

Hi,

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?

Labels (2)
3 Replies
Highlighted
Creator
Creator

You can 'unpivot' these columns and use the unpivoted column names as your dimension in the data manager.

93/93
Highlighted
Creator
Creator

Hi, 

I don't understand the solution. Which fields do I drag and drop as dimention and where can I "unpivot"?

Highlighted
Creator
Creator

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.

93/93