topic AW:Re: Always show all dimensions in a Bar Chart in QlikView

Always show all dimensions in a Bar Chart

Thu, 08 Oct 2009 22:12:59 GMT

Hi all!

I have a Bar Chart with Month as a Dimension.

is there a way to permanently show all the Dimensions?

So even though only Jan and Feb are clicked. March till Dec still appear on the chart?

I would appreciate your help!!!

Andi

Always show all dimensions in a Bar Chart

Thu, 08 Oct 2009 22:40:22 GMT

I had this exact same issue. I resolved it be creating a lookup table tied to the data through the month and used a field from the lookup table in the bar chart. You can then set the chart to show null values and all months from the lookup table will show.

AW:Re: Always show all dimensions in a Bar Chart

Fri, 09 Oct 2009 15:27:01 GMT

Thanks for your effort!

But in this case i cannot change the DataModel behind. So is there a FrontendWay of solving this issue?

Andi

AW:Re: Always show all dimensions in a Bar Chart

Wed, 17 Feb 2010 17:51:38 GMT

Hello,

this works for Bar charts.

In chart properties, presentation: Uncheck Suppress zero values and uncheck suppress missing.

In Chart properties, Dimensions for the month dimension: Check Supress When Value is Null and check Show All Values.

Haven't been able to do this for tables though which is very annoying. If anyone have a solution for tables (pivot or straight) I would be thankful.

Re: Always show all dimensions in a Bar Chart

Wed, 29 Jan 2014 16:32:28 GMT

Here is a simple method that works:

You want to see if a Region does not sell anything for any calendar period

Ensure you have a counter in your dimension table eg: 1 as RegionCounter

Create your normal bar chart with Region as dimension and sum(YourSalesField)

as expression

Create a second expression

=sum({<Year=,Quarter=,Month=>}RegionCounter)+1

For this expression, in display Options, untick Bar

Just above it tick invisible

( the +1 ensures that there is always a value in the field)

Re: Always show all dimensions in a Bar Chart

seb-custics — Thu, 26 Jul 2018 11:36:09 GMT

Hi Andras,

Have you try this : Trick Qlik Sense to show all values by using a different Measure.

For instance, if you want to show Sum( Sales ) then you can use the following expression instead: Sum( Sales ) + 0 * Sum( {1} Sales )