Condense width of combo chart

[kalmirall]

When creating a combo chart, is there a way to condense the width of the graph by not showing spaces for missing values for a list of metrics?

[ogster1974]

Also in data handling you have the option to not show zero values.

[kalmirall]

Thanks Andy!  Does that mean in your data set, that for blank or null values you'll need to have zero values there?  Is there a way to have null/blanks recognized as zeros from within Qlik without manipulated the data set?

[ogster1974]

‌yes Katie.  In your measure expression wrap it in a if statement.  Something like

=if(<your expression>=null(),0,<your expression>)

ALso on your dimensions in your chart you have a setting to show null values make sure that is unticked.

HOpe this helps

Andy