Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Always show all dimensions in a Bar Chart

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

5 Replies
Not applicable
Author

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.

Not applicable
Author

Thanks for your effort!

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

Andi

Not applicable
Author

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.

Not applicable
Author

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)

seb-custics
Contributor II
Contributor II

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 )