topic Re: Pie Chart data display. in QlikView

Pie Chart data display.

Sat, 30 May 2015 06:05:56 GMT

Hi,

Can some one help me in solving my requirement.

I have a pie chart which displays country wise top 10 sales records. I want to display the records based on decreasing order of sales.

Attached Image for reference.

Thanks in Advance.

Re: Pie Chart data display.

PrashantSangle — Sat, 30 May 2015 06:12:54 GMT

Hi,

Go to sort->expression -> Write Expression -> Desending

Regards

Re: Pie Chart data display.

veeranj — Sat, 30 May 2015 06:41:12 GMT

Hi,

Go To Dimension limits and set show only(largest) to 10 values.
Now go to Sort and write the expression over there and select descending option.

Thanks

Anjee

Re: Pie Chart data display.

Sat, 30 May 2015 12:44:13 GMT

Thanks for your reply.

I have set those properties but its not working.

Re: Pie Chart data display.

Sat, 30 May 2015 12:47:30 GMT

Thanks for your reply.

I have set the dimension limits . What expression do i need to write in sort?

Re: Pie Chart data display.

swuehl — Sat, 30 May 2015 13:05:21 GMT

Either use sort option 'y value' and descending in sort tab, or try repeating your expression on expression tab also as sort expression in sort tab.

Something like

=sum(Sales)

It would make things a lot easier if you describe what settings you are using in your chart, i.e. which dimension, which expression, and other options you've set.

At best, post a small sample QVW.

Re: Pie Chart data display.

Sat, 30 May 2015 13:27:55 GMT

Hi Swuehl,

Thanks for your reply.

I have one dimension i.e Country, one expression i.e Sum(Sales) and selected the relative option. In Sort tab for Sum(Sales) i have selected the descending option and for country i have selected the order as A-Z. But it is not showing in descending order of their percentages.

Do i need to write any expression in Sort?

Re: Pie Chart data display.

swuehl — Sat, 30 May 2015 13:34:05 GMT

Not sure where you've find the sort tab for your expression.

Disable the text sort order for your dimension.

Enabling the sorting the dimension by Y-value descending should do what you want.

Alternatively, use the sort by expression sort option with sum(Sales).

Re: Pie Chart data display.

Sun, 31 May 2015 02:45:11 GMT

Thanks Swuehl.

Now i got it.

Re: Pie Chart data display.

pratap6699 — Sun, 31 May 2015 20:47:50 GMT

dimension limits-->display 10

sort-->sum(sales)

expre-->sum(sales)