topic Re: Remove from chart bars with value zero/blank in QlikView

Remove from chart bars with value zero/blank

Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I have a table with variables Amount, Company, Day and Quantity.

I built a bar chart with 3 dimensions: Amount -> Quantity -> Company. In my expression, I used Avg(Quantity). After all steps I got this bar chart:

The question is how to remove all Quantity values from X axis if a certain Amount value does not have relative Quantity values. The example is above.

Re: Remove from chart bars with value zero/blank

settu_periasamy — Sun, 06 Mar 2016 12:47:47 GMT

Hi,

Check the 'Text on Axis' in the Expression Tab..

Re: Remove from chart bars with value zero/blank

Sun, 06 Mar 2016 14:26:05 GMT

settu_periasamy‌, it is not text on value. The main aspect is to shift bars to the left by removing unnecessary Quantity values/labels. I don't want large spaces between bars.

Re: Remove from chart bars with value zero/blank

sunny_talwar — Sun, 06 Mar 2016 19:11:29 GMT

Would you be able to share a sample to take a deeper look at the issue?

Re: Remove from chart bars with value zero/blank

settu_periasamy — Mon, 07 Mar 2016 02:01:09 GMT

Hi,

May be you can try to remove the Quantity field from your dimension (already it is in expression).. check the below screen shot from reference Manual.

I removed the Quantity, and style as 'Stacked'

Re: Remove from chart bars with value zero/blank

jagan — Mon, 07 Mar 2016 02:19:51 GMT

Hi,

It is not possible, Qlikview Reserves equal amount of space for the first dimension values, the axis space is split into equal area.

Regards,

jagan.

Re: Remove from chart bars with value zero/blank

Mon, 07 Mar 2016 17:51:29 GMT

settu_periasamy‌, thanks for the advice. However, it works unless there are no duplicate Amount values. If there are, the chart will look like that:

P.S. I have added data files to the first post.

Re: Remove from chart bars with value zero/blank

settu_periasamy — Tue, 08 Mar 2016 03:02:22 GMT

I think, it is working fine as per the Dimension. for e.g the Qty -8 is available on the Amount Fields, 15,18,21, 27 12 (These are all Company B) and 24 (This value belongs to Company A.

How do you want to display?

Re: Remove from chart bars with value zero/blank

Tue, 08 Mar 2016 06:15:32 GMT

settu_periasamy‌, I thought it is possible to separate both Amount and Quantity. However, if it is not, I will deal with stacked option.