Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dmohanty
Partner
Partner

Pie Chart dimension values in a Clockwise format?

Hi All,

Suppose I have a data in this format:

Experience GroupNumbers
Rookie150
1-3 yrs90
3-5 yrs110
5-9 yrs70
9 + yrs40

Requirement:

I want to show this in a Pie Chart, but the Dimensions are getting placed random. I want the Dimension Value in Clockwise (serially)

My need is for example:

  • Rookie will be at Top.
  • Moving clockwise, 1-3 yrs
  • Then 3-5 yrs
  • Then 5-9 yrs
  • Then it will end at 9+ yrs

How can this functionality be possible?

Regards,

Dicky Mohanty

1 Solution

Accepted Solutions
maxgro
MVP
MVP

you can add a field and use it to sort by expression

load rowno() as id, * inline [

Experience Group, Numbers

Rookie, 150

1-3 yrs, 90

3-5 yrs, 110

5-9 yrs, 70

9 + yrs, 40

];

1.png

View solution in original post

1 Reply
maxgro
MVP
MVP

you can add a field and use it to sort by expression

load rowno() as id, * inline [

Experience Group, Numbers

Rookie, 150

1-3 yrs, 90

3-5 yrs, 110

5-9 yrs, 70

9 + yrs, 40

];

1.png

View solution in original post