topic Re: Dimension as label in bar chart in QlikView

Dimension as label in bar chart

Thu, 03 Sep 2015 08:10:18 GMT

I want to show a dimension as a label in a bar chart, without showing it as a legend or an axis. How do I do this?

Re: Dimension as label in bar chart

qlikmsg4u — Thu, 03 Sep 2015 08:12:35 GMT

Use Text in Chart option

Re: Dimension as label in bar chart

Thu, 03 Sep 2015 09:03:11 GMT

Hi- that's not working. I'm trying to add a calculated dimension

Re: Dimension as label in bar chart

gautik92 — Thu, 03 Sep 2015 09:05:11 GMT

go to presentation tab and add text in chart

Re: Dimension as label in bar chart

Thu, 03 Sep 2015 09:07:59 GMT

That's what I did

Re: Dimension as label in bar chart

gautik92 — Thu, 03 Sep 2015 09:15:25 GMT

still you dint get?

Re: Dimension as label in bar chart

qlikmsg4u — Thu, 03 Sep 2015 09:21:24 GMT

Uncheck Show Legend and and Label in Dimension

and hard code the names in Presentation > Add Text

using Ctrl+Shift you can move these texts where ever you want

Re: Dimension as label in bar chart

Thu, 03 Sep 2015 09:36:37 GMT

Hi this is an example of what I'm trying to do. On the bars I want to show the result of

if(rule2='blank',rule,rule2)

Re: Dimension as label in bar chart

Anonymous — Thu, 03 Sep 2015 09:45:56 GMT

HI madelein

maybe check "Plot Values Inside Segment" in Presentation Property (tick this check box)

Regards,

gireesh

Re: Dimension as label in bar chart

sunilkumarqv — Thu, 03 Sep 2015 09:58:36 GMT

Hope this will help you

Example:

1. Create a pie chart with Country as the dimension. Add the following expressio n:

=Dual(

if(Len(Only(Country))>0, Country, 'Others')

& chr(10) & Num(Sum(Sales), '#,##0')

,Sum(Sales)

)

2. On the Expression tab, label the expression as Sales $ and turn on the

Values on Data Points option.

3. On the Sort tab, turn on the Y-Value option.

4. On the Presentation tab, turn off the Show Legend option.

5. On the Numbers tab, ensure that Expression Default is selected.

6. Click on OK to save the chart. Note that the country names and values

are displayed besides each segment.

Re: Dimension as label in bar chart

Thu, 03 Sep 2015 10:32:36 GMT

found the solution. Thx for everyone help!