topic Chart Display? in QlikView

Chart Display?

knightwriter — Fri, 11 Apr 2014 09:32:01 GMT

Hi All,

I have two queries with my chart I am trying to create.

1) Why is there a gap between the x-axis and where the bar chart starts? And how do I fix this?

2) Is there a way I can turn off the data point when no selections have been made and then when I make a selection the data points will show ?

Thanks in advance.

Stephen

Re: Chart Display?

yduval75 — Fri, 11 Apr 2014 09:35:32 GMT

Select your bar chart and then Click on CTRL + SHIFT and move the dimensions of your bar chart

Re: Chart Display?

kji — Fri, 11 Apr 2014 09:37:28 GMT

1) i assume there are negative values if you scroll to the right which means the zero level will be pushed up, not sure why the axis doesent show values below zero though.

2) on the presentation tab of properties you can set "Max Values Shown" for Values on data points, so its only shown when the number of bars is less than what you enter.

Re: Chart Display?

its_anandrjs — Fri, 11 Apr 2014 09:39:19 GMT

1. Use plot value inside the segment.

2. As yoann suggest click on chart and then press Ctrl + Shift for adjustment of the chart display area.

Re: Chart Display?

MK_QSL — Fri, 11 Apr 2014 09:41:39 GMT

1) Click on chart

now CTRL + SHIFT

you will see Red Boxes... Using your mouse, you can now set the width and height of Chart which will reduce the gap on x-axis

2) Create two same expressions

For 1st Expression :

SUM(Sales)

Select Bar and untick Values on Data Points

For 2nd Expression

IF(GetSelectedCount(Customer)<>0,SUM(Sales),'')

Untick Bar Chart and Tick Values on Data Points

Here is you select any Customer, then only data points will appear....

Of course, you need to change your expression according to your need..

Re: Chart Display?

rustyfishbones — Fri, 11 Apr 2014 09:42:50 GMT

Hi Stephen,

Try selecting Force Zero for issue 1.

For issue 2 you may need to use Alternate States so it shows all bar, but the number only appear when you have selected them.

If you share a reduced version of the App I will try and help

Regards

Alan

Re: Chart Display?

Fri, 11 Apr 2014 09:43:25 GMT

I think there are some negative values..!

Re: Chart Display?

nizamsha — Fri, 11 Apr 2014 09:46:23 GMT

first thing u may have negative value in ur bar ,it its not clik on the chart object and use ctrl+Shift to reduce the gap

Re: Chart Display?

Fri, 11 Apr 2014 10:02:27 GMT

you can ctrl + click and move the dimentions or try changing the chart into a horizontal graph though properties

Re: Chart Display?

rustyfishbones — Fri, 11 Apr 2014 10:19:41 GMT

Hi Stephen,

Are you looking for something like this

Re: Chart Display?

knightwriter — Fri, 11 Apr 2014 11:35:37 GMT

Hey Alan,

Hows things? Thanks for the reply. Wasnt expecting the 9 or so in such a quick response. I'm going to take a look at your Alternative states youtube vid to sort the selection choice.

I had negative values at the end of the axis so boxed off that first query!

Speak soon,

Stephen

Re: Chart Display?

rustyfishbones — Fri, 11 Apr 2014 11:44:10 GMT

Ok,

good luck, are HSBC using QV, or you using it yourself?