Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to display zero on axis for the bar which has missing values in qlikview bar chart
Insert zero-records into your facts table(s)?
QlikView won't calculate anything if data is non-existent and you cannot force it to do otherwise by selecting one or more checkboxes...
Or create a date data-island and use that for the dimension. This does not require messing with the fact table, but will not perform as well on really large data sets. See this link for more:
Showing Missing Time Data on a chart axis
Check out the blog link in the above thread as well.
go to chart properties, then presentation and check the Zero on Bars options
I dont think that will help with missing values...
it will work only in case of line chart i have done, but in bar chart with multiple expression not working but works with one expression