Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ 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.