topic Re: Condense width of combo chart in App Development

Condense width of combo chart

kalmirall — Thu, 24 Sep 2015 13:48:42 GMT

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?

Re: Condense width of combo chart

ogster1974 — Thu, 24 Sep 2015 15:25:39 GMT

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

Re: Condense width of combo chart

kalmirall — Thu, 24 Sep 2015 17:51:39 GMT

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?

Re: Condense width of combo chart

ogster1974 — Fri, 25 Sep 2015 07:06:35 GMT

‌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