Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
MuraliPrasath
Contributor II

Pie-Chart Quest?

Hi,

I've a Pie-Chart expression values like this.

Inv.JPG

I need to show my values in MY ORDER STYLE like below, instead above Row Lables.

1.Stock

2.Credit Hold,

3.CPU,

4.Planned for Delivery/Shippment

5.Premier

6.Production & Rework

7.Unplanned

8.Return.

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Pie-Chart Quest?

You could use an expression to sort your dimension (in tab sort), like:

pick(match(YourDimension, 'Stock', 'Credit Hold', ...), 1, 2, ...)

- Marcus

View solution in original post

4 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Pie-Chart Quest?

You could use an expression to sort your dimension (in tab sort), like:

pick(match(YourDimension, 'Stock', 'Credit Hold', ...), 1, 2, ...)

- Marcus

View solution in original post

Highlighted
Not applicable

Re: Pie-Chart Quest?

Hello,

You can create an Inline for this type sorting.

Highlighted
MVP & Luminary
MVP & Luminary

Re: Pie-Chart Quest?

You can load a dummy table to establish the sort order.

http://qlikviewcookbook.com/2012/11/establishing-a-sort-order/

-Rob

Highlighted
MuraliPrasath
Contributor II

Re: Pie-Chart Quest?

thank you sooooo much Marcus. It worked 🙂 Keep up your good work.