How can I show the zeros in one graphic? - Qlik Community

mlarruda · ‎2019-01-29

By default, the graphics skip the zero values. E.g. if I have two columns (YEAR with values 2015, 2016, 2017, 2018 and PROFIT with values 500, 200, 0, 300), the x-axis of the graphic (dimension = YEAR and expression = PROFIT) will skip 2017 and jump from 2016 to 2018:

How can I avoid it and make the graphic show the zero in 2017?

Many thanks in advance.

sergio0592 · ‎2019-01-29

Check in the presentation tab, that "Supress zero value" option is unchecked.

mlarruda · ‎2019-01-30

Thanks. In this simple example it worked. But my real database is a bit more complex.

Suppose that I have THREE columns: YEAR, PROFIT and COMPANY_NAME.

When I select a specific company name, the system automatically filters the other columns. So, when I select "B Inc" only rows with years 2015, 2016 and 2018 will remain and will be plotted. How can I make the 2017's zero appear in THIS graphic?

sergio0592 · ‎2019-01-31

Ok, You have to check in dimension "Show all values".