Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

kalmirall
New Contributor II

Condense width of combo chart

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?

3 Replies
ogster1974
Honored Contributor II

Re: Condense width of combo chart

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

kalmirall
New Contributor II

Re: Condense width of combo chart

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
Honored Contributor II

Re: Condense width of combo chart

‌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