is it possible to display all values of a chart in a pre-selected time frame?
The problem is, that the values can range between 0 and 100 (percent), but there aren’t values for every timestamp. I can’t replace every missing value with 0, because then you couldn’t differentiate between the real 0’s and the ‘fake’ 0’s
As an example the graph should show all values in the last 31 days, but there are only two data points. Qlik now cuts off on both sides the times, which don’t have a value assigned to it. The timeframe should be between the 2019-02-26 and the 2019-03-28, but ranges only from 2019-02-28 to 2019-03-14.
As a start I tried to give every time an additional measure, which is always 0, so that, when I use both in one graph, it shows the whole time frame.
Which looks like this:
Now the Problem is, that there is for every day a null value and you cant see the real 0 like in the first graph.
Additionally I can’t not display the new values, because then it would look like the first graph again.
If this is not possible in native Qlik Sense – is there any extension around (didn’t find any - yet) which has this possibilities?