topic Pie Chart Labeling in QlikView

Pie Chart Labeling

Thu, 28 Jul 2011 17:39:06 GMT

Hey everyone-

Been trying to build out a pie chart which includes labeling for the values and the "category" itself. I know the methodology: create seperate expressions for the %, count/sum, and then for the categoyr label.

The problem that I've run into is what to do about "Others?" In my chart, it comes up as blank:

Notice that nothing shows up for "Other." Not even percentages, count, let alone the label. What can I do to get these values into the pie chart for "Others?"

Pie Chart Labeling

mazacini — Thu, 28 Jul 2011 18:13:47 GMT

Did you try the 'Label for Other Slice' in the Presentation tab?

Pie Chart Labeling

rahulgupta — Mon, 01 Aug 2011 09:09:38 GMT

Hi,

You can use Suppress When the Value is Null in the Dimension Tab, if you dont want that to be represented Else you can use a calculated dimension as If(Isnull(FieldName),'Others',FieldName).

Hope this helps..

Regards