topic Pie Chart, problem with labelling Expression in QlikView

Pie Chart, problem with labelling Expression

marleygt — Wed, 01 Jul 2015 15:32:28 GMT

Hi all!

I need to display data names of legend on slices's pie chart of my project.

I found a discussion which should be somehow good for my case here.

Now, problem is I try first to use same sintax shown in the other discussion ---

Dual('MyLabel' & chr(10) & num(MyExpression, '0.0%'), MyExpression) ---

but is not working at all, displaying this message: "all values below limit".

Original (working) Expression is: sum( {<Regions -={'5000'}>}$(vSales))

and it's showing classical pie chart with legend and slices.

Request from customer is if possible to display same name in legend, on (or next to) slices of pie chart.

Dimension used is called DimensionFields and it contains 5 different dynamic fields.

Dimension is settled this way: =$(=DimensionFields)

Referring to expression above, I tryout this:

=Dual($(=DimensionsFields) & chr(10) & num(sum( {<Regions -={'5000'}>}$(vSales)),sum( {<Regions -={'5000'}>}$(vSales))))

I am not able to simulate right now with a sample, hope this could be enough to understand.

Any suggestion about the correct way to create a working expression with those data?

THANK YOU!

Alex

Re: Pie Chart, problem with labelling Expression

sunny_talwar — Wed, 01 Jul 2015 15:43:04 GMT

Do you have a sample you can share? It will be easier to have a look at the sample

Best,

Sunny

Re: Pie Chart, problem with labelling Expression

marleygt — Fri, 03 Jul 2015 13:56:48 GMT

Hi Sunindia!

Well, I've insisted a little bit on it...and I did it!

=Dual(

$(=DimensionsFields)& Chr(10) & num(Sum( {<Regions -={'5000'}>}$(vSales)) Sum( TOTAL{<Regions -={'5000'}>}$(vSales)))),'0,00%' ),

Sum( {<Regions -={'5000'}>}$(vSales))/Sum( TOTAL{<Regions -={'5000'}>}$(vSales))))

)

However, final result was not acceptable at all: in total displaying, information are too much and pie chart become too little or completely disappearing, moreover that legend's fields on slice, are overlapping.

So...I found the right expression but is not applicable this time.

Thank you anyway!

Alex