Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Netsroht92
Contributor
Contributor

display all values in a fixed timeframe

Hello,

 

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.

Version 1.PNG

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:

Version 2.PNG

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?

 

 

Regards Thorsten

0 Replies