Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Also in data handling you have the option to not show zero values.
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?
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