topic pie chart question in QlikView

pie chart question

Tue, 11 Jan 2011 18:54:22 GMT

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.

pie chart question

johnw — Tue, 11 Jan 2011 20:04:12 GMT

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

pie chart question

Tue, 11 Jan 2011 20:09:16 GMT

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%

pie chart question

johnw — Tue, 11 Jan 2011 20:30:52 GMT

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.

pie chart question

hector — Tue, 11 Jan 2011 20:33:01 GMT

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

pie chart question

johnw — Tue, 11 Jan 2011 20:44:58 GMT

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.

pie chart question

Tue, 11 Jan 2011 23:45:04 GMT

Hi John,

Your first solution creating a seperate Expression worked for me.

For some reason i couldnt get Dual to work