pie chart question

[#1]

How do i draw lines from each segment on the pipe chart and make the data static ..

Chart now shows data as pop up. but i want to draw lines from each segment and make data static instead of the data appearing only when you mouse over.

[johnw]

If I understand the question, Properties -> Expressions -> checkmark "Values on Data Points".

[#3]

value on data points just shows the expression numbers. I also want to display the dimension name with the expression numbers.

Eg, Asia 23% instead of just 23%

[johnw]

One way is to add a second expression of ="Country", and again select Values on Data Points. That would show 23% and then Asia on a second line. Not exactly what you want, but close. I thought maybe the dual() function would let you do it exactly, but it seems to display the number instead of the text.

[hector]

Hi,

maybe using dual()

check this link http://community.qlik.com/blogs/qlikviewblogs/archive/2010/06/23/more-on-dual-quot-others-quot-in-chart-using-aggr.aspx

Rgds

[johnw]

Hmmm, I wonder why dual() isn't working for me, then. Oh, duh. I didn't notice that I was using "relative". Of course it won't work with relative. Removing that lets the dual() work, or I can calculate the relative value myself. Attached is doing it calculating the relative value myself.

[#7]

Hi John,

Your first solution creating a seperate Expression worked for me.

For some reason i couldnt get Dual to work