topic Re: Display expression values inside a bar in bar chart in QlikView

Display expression values inside a bar in bar chart

Mon, 09 Jul 2012 14:14:07 GMT

Hi All,

Doubt 1 : I want to display the values of the expression inside a bar in bar chart. I tried options like Test in Chart, values on data points .

Attached is the qvw file. Also I am giving a link (desired output format) : http://www.google.com/imgres?um=1&hl=en&sa=N&biw=1366&bih=667&tbm=isch&tbnid=1sJvxRHX3JR1RM:&imgrefurl=http://www.jpowered.com/graph_chart_collection/bar-graph.htm&docid=41HYk7EhjqgFSM&imgurl=http://www.jpowered.com/graph_chart_collection/graph-images/stacked-bar-graph.gif&w=384&h=342&ei=wOP6T5Rw5d7RAdCF8MQG&zoom=1&iact=rc&dur=478&sig=111711914311597077086&page=2&tbnh=149&tbnw=158&start=16&ndsp=23&ved=1t:429,r:14,s:16,i:172&tx=15&ty=79

Doubt 2: Also, I want to know how to get the axes shown on the qlikview chart. I select show grid but that only shows grids inside the chart not the x axis and y axis. Is there an option to get the axes.

Doubt 3 : Is there a way to append a symbol to the text shown on X axis or Y axis???

Re: Display expression values inside a bar in bar chart

MayilVahanan — Mon, 09 Jul 2012 14:25:05 GMT

Hi,

Check the attached file.

I didn't understand the third question.. Can u explain in brief..

Hope it helps

Re: Display expression values inside a bar in bar chart

Mon, 09 Jul 2012 14:27:50 GMT

Hi Mayil,

Thanks for that. But as I said, I am using a free personal edition, I cannot view that .

anyway , I got to show the expression value inside the bar but i need a way to format it, because the value is too big for the bar and the text prints outside the bar .

Mayil, if you can send the screen shots it will be of great help.

Thanks!

Re: Display expression values inside a bar in bar chart

Mon, 09 Jul 2012 14:37:33 GMT

3rd question :

On the Y axis, I can see only values which are populated by qlikview. I want to append a letter to it.

Say, if it is 100 , I want to append the symbol of currency we are using .so that will be 'X100' (say X is the currency )

Re: Display expression values inside a bar in bar chart

MayilVahanan — Mon, 09 Jul 2012 14:41:53 GMT

Hi,

In Properties -Axes->set Width for Expression Axis and dimension Axis..Want to change color means use Axis color

For grid-> tick Show gird in axes page..Grid Style select acording your requirement , for color choose in Grid color.

In Presentation tab -> tick Plot value inside Segment, for vertical tick vertical in same tab..before that, tick Values on Data Point in Expression tab..

Re: Display expression values inside a bar in bar chart

Mon, 09 Jul 2012 14:51:53 GMT

Hi Mayil,

It helped but as I said I got to display the values inside the bar, but I want to format it and also the expression values are too big for the bar(vertical or horizontal). Is there a way to format the expression value before displaying??

Re: Display expression values inside a bar in bar chart

MayilVahanan — Mon, 09 Jul 2012 14:58:34 GMT

Hi,

Can you post a example or sample screen shot for your requirement..Its help to solve it..

Re: Display expression values inside a bar in bar chart

Mon, 09 Jul 2012 15:04:45 GMT

Hi mayil,

Please find the attached for screenshot.

As you can see, I have goit the expression value to display inside the bar, but the value is too big for it to fit in the bar.

So, I wnat to format the value before displaying.

did that help?

Please let me know if you need any other info

Re: Display expression values inside a bar in bar chart

Mon, 09 Jul 2012 15:09:02 GMT

Mayil,
As you can even the values shown on Y axis are big, is there a way to format that(like dividing it by 10^6) and putting millions against it?

Re: Display expression values inside a bar in bar chart

MayilVahanan — Mon, 09 Jul 2012 15:12:24 GMT

Hi,

Try this,

Use Properties -> Number ->Million Symbol like this ->(M)

It will reduce the value in Y axis..

And you can't reduce the getting result. If you reduce means, the answer vary..So you can use change the width of the chart..Still the value display in bar..

Hope it helps

Re: Display expression values inside a bar in bar chart

Mon, 09 Jul 2012 15:17:16 GMT

Ok.

May be I can modify the expression itself so that value generated is less in width.

Re: Display expression values inside a bar in bar chart

Mon, 09 Jul 2012 15:24:58 GMT

Mayil,

Is there an option to control the size(width) of the bar in bar chart??

Re: Display expression values inside a bar in bar chart

Mon, 09 Jul 2012 15:30:44 GMT

Well the option width under caption is to increase the window size of the entire bar chart. I want to increase the width of the bar without changing the frame size of the bar chart

Re: Display expression values inside a bar in bar chart

MayilVahanan — Mon, 09 Jul 2012 15:32:12 GMT

Hi,

In Expression divide by Million and used in the Properties -> Number -> Symbol as (M)..

So the chart is appear something like below..

Hope it helps

Re: Display expression values inside a bar in bar chart

jagan — Mon, 09 Jul 2012 15:34:16 GMT

Hi Uday,

Increase width of the chart, so that the bar width is also automatically increased.

Regards,

Jagan.

Re: Display expression values inside a bar in bar chart

Mon, 09 Jul 2012 15:36:18 GMT

Hi Jagan,

thanks for the reply. But I want to increase the width of the bar without increasing the width of the chart.

Thanks!

Re: Display expression values inside a bar in bar chart

MayilVahanan — Mon, 09 Jul 2012 16:10:35 GMT

Hi,

I think for bar width alone in bar chart is not possible. So you can change the width of the chart. Did u try for divide by million .. I think that can useful for your requirement