topic Re: Dimension as label in pie chart in QlikView

Dimension as label in pie chart

Wed, 09 Jul 2014 08:46:06 GMT

Hello, I want to use pie chart along with table only as graphic expression of data in table. So I dont need to have expressions shown "on data points" but I want to have Dimension there instead.

Like here:

Thank you!!

Re: Dimension as label in pie chart

MK_QSL — Wed, 09 Jul 2014 08:49:48 GMT

go to presentation tab and select Show Legend and Show numbers in legend

Re: Dimension as label in pie chart

datanibbler — Wed, 09 Jul 2014 08:51:01 GMT

Hi Viktor,

well, not displaying the figures in the chart should be doable by unchecking the checkbox on the "expressions" tab in the properties dialog.

As to displaying the dimension - you'd have to either use a caption to the chart or make a textbox with a transparent background and place it in the middle of the ring.

Best regards,

DataNibbler

Re: Dimension as label in pie chart

Wed, 09 Jul 2014 08:59:42 GMT

Noooooo ...Is that really the only way how to display dimension label in pie chart? - by using the textbox?

Uff ...I am bit disappointed now

Re: Dimension as label in pie chart

Wed, 09 Jul 2014 09:02:18 GMT

With no response... and I tried it with checked and also unchecked "Values on Data Points" in Expressions tab

Re: Dimension as label in pie chart

datanibbler — Wed, 09 Jul 2014 09:03:36 GMT

Hi,

I just looked in an app where I have a piechart - you can also use a "free_text" ("presentation" tab) which is part of the chart. You can of course use a field - your dimension - to display there and you can position it anywhere in the charting_area => Put the zoom_factor to 200 or so to be able to position it precisely, it is a bit fickle to do.

Re: Dimension as label in pie chart

Wed, 09 Jul 2014 09:06:58 GMT

Try like this Presentation--> Text in chart

Re: Dimension as label in pie chart

Wed, 09 Jul 2014 09:13:36 GMT

Yes, I just discovered the "Text in Chart" field in presentation tab. It creates text fields as part of the chart which are able to move using ctrl+shift.

As I am a beginner and have very small understanding for codes ...can you tell me if there is a possibility to tell the Qlickview to put the dimension label there automatically?

If I have to make only few Pcharts, the "text in chart" feature is OK, but I have to do it for mabye 50 car brands every month... so I am looking for more autonomous solution.

Re: Dimension as label in pie chart

sasikanth — Wed, 09 Jul 2014 09:22:09 GMT

hi ,

One other way is there ,

try to concat both fields like

lLOAD

categories,

class,

categories&'-'&class as CAT_CLASS,

From........Table

use that field in your pie chart

Re: Dimension as label in pie chart

er_mohit — Wed, 09 Jul 2014 09:24:55 GMT

See the attached file

Re: Dimension as label in pie chart

Wed, 09 Jul 2014 09:36:38 GMT

Thank you Sasikanth, but the problem is not to show dimension as "Kategorie Class" but to show the dimension itself instead of expression (which is defaultly shown).

Re: Dimension as label in pie chart

Wed, 09 Jul 2014 10:18:43 GMT

Thank you, but my employer still does not have bought a license

Re: Dimension as label in pie chart

datanibbler — Wed, 09 Jul 2014 11:44:58 GMT

Hi Viktor,

well, without a license, what are you supposed to be doing?

Do you work with the "Personal edition"? That means that only you - your logon, that is - can view the apps you create and it won't work for any other user/ logon - so you would have to do it all again for anyone else to see ...

Re: Dimension as label in pie chart

Wed, 09 Jul 2014 11:56:11 GMT

Actually, anyone with a license can open my apps, but I cant open, what anyone else did.

And exports for our needs: using Nprinting Client or normally by Export - png... mostly enough.

Re: Dimension as label in pie chart

hugmarcel — Wed, 21 Jan 2015 09:32:21 GMT

Very nice! Congrats!

marcel

Re: Dimension as label in pie chart

isingh30 — Fri, 02 Feb 2018 14:42:01 GMT

Please check this. Let me know.

Thanks.