topic Re: Bar Chart in QlikView

Bar Chart

Thu, 11 Feb 2016 20:20:36 GMT

How to hide the dimension if the value of the expression is null or zero in bar chart..

Thank you

Re: Bar Chart

sunny_talwar — Thu, 11 Feb 2016 20:44:34 GMT

May be try checking 'Suppress Zero Values' on the presentation tab of the chart properties

Re: Bar Chart

Thu, 11 Feb 2016 20:49:47 GMT

Tried but no use..can we make the text color white conditionally for the dimension..

Re: Bar Chart

Thu, 11 Feb 2016 21:04:36 GMT

Dimensions:

Month(Complete)

Accountable

Complexity

Expression:Count(Complete)

I need to disable the name in accountable for example ''barywhitlow'' in first group of bars

Re: Bar Chart

sunny_talwar — Thu, 11 Feb 2016 21:20:12 GMT

Would you be able to share the application?

Re: Bar Chart

Anonymous — Thu, 11 Feb 2016 21:44:49 GMT

Did you try creating a calculated dimension? Something like if(Count(Complete) >0, Accountable,). The result of this expression depends on the dimensions you have in the chart. Also, using Dimension Limit allow us to control the no. of dimensions to be visible but the options there may not be suitable for the use case there. Give a try.

Re: Bar Chart

satishkurra — Thu, 11 Feb 2016 21:55:57 GMT

Seems like this is a blank value instead of NULL.

Please try the below in load script:

Where

len(trim(ColumnName)) > 0

In Calculated dimension

=if(len(trim(ColumnName)) > 0, 'NULL','ColumnName')

Thanks

Satish

Re: Bar Chart

sfatoux72 — Thu, 11 Feb 2016 22:36:50 GMT

You cannot create asymetric bar chart.

''barywhitlow'' appears in the first group, because it have a value in the second group.

You can use the following trick:

Create a calculated dimension ( Month & ' - ' & Accountable ) instead of using dimensions Month and Accountable
Use expression to sort this calculated dimension correctly

The presentation won't be the same, but you will have only bars with data.

If it's good for you, you could creat this dimension directly in the load script

Re: Bar Chart

rwunderlich — Thu, 11 Feb 2016 23:21:06 GMT

When you have multiple dimensions, The value will show in all groups if there is at least one non-zero value in any group. Barry has data in February, so Barry will show for all months. The groups are always made symmetrical. And no, I don't think there is a way to color Barry's background white in just Jan.

Perhaps someone else knows a data trick.

-Rob

Re: Bar Chart

Thu, 11 Feb 2016 23:45:12 GMT

Thank you fatoux i will try and let u know ...

Re: Bar Chart

Thu, 11 Feb 2016 23:45:38 GMT

Thank you Rob

Re: Bar Chart

jagan — Fri, 12 Feb 2016 02:07:20 GMT

Hi,

Try like this in

Properties -> Dimension -> Select Dimension -> Enable Condition and give below condition

=Alt(Sum(SomeMeasureName), 0) <> 0

HOpe this helps you.

Regards,

Jagan.

Re: Bar Chart

rwunderlich — Fri, 12 Feb 2016 18:54:37 GMT

Note that as of QV11 SR13 or QV12, you can have multi-line x-Axis labels (without using diag option). So your calculated dim can include a line feed:

Month & chr(10) & Accountable