Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
amiroh81
Creator
Creator

Line graph display when there is no data

Hi,
I have a graph that shows data at hour or minute intervals.
When there are situations where there is no data at all, a line is created between the last point that is given and the next point forward and this can confuse the user (you might think that data exists at the same time).
In practice, the situation is understandable, since the values are NULL.
Is there a creative solution to overcoming this virtual line? I would prefer line 0 if possible, so the user will obviously have no data.
Thanks in advance

Labels (2)
4 Replies
sunny_talwar

I think right now the data is missing which is why you see a line getting connected here... but to make it 0, you might need to generate missing data

amiroh81
Creator
Creator
Author

Thanks so much for the direction.
If I understand correctly I should create all possible intervals to see line 0.
This is problematic for me because my report will be updated every time and sometimes there are different intervals.
Is there a simpler way?
Is there a possibility that the line will not connect between its two ends?

sunny_talwar

Can you try unchecking 'Suppress Zero-Values' from the Presentation tab of the chart properties and see if that works for you.

amiroh81
Creator
Creator
Author

I tried but it didn't help.
By default, the QV seems to connect the dots and I couldn't find a way to cancel it.