Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sophie_bd
Partner - Contributor III
Partner - Contributor III

Continous graph with period

Hello,

 

how to do a continous period il a bar chart when I have null value ?

I don't want a date.

 

clipboard_image_0.png

 

Best regards,

Sophie

4 Replies
_armoco_
Partner - Creator II
Partner - Creator II

Hi Sophie,

Could you elaborate?

You can remove null values by unchecking 'Including null values' from dimension

clipboard_image_0.png

Also try unchecking 'Include zero values' from Data handing tab

clipboard_image_1.png

Regards,

Arjun

 

 

sophie_bd
Partner - Contributor III
Partner - Contributor III
Author

Hello,

 

i have a selection with no data for the dates, so no data on the graph:

 

i have try 'Including null values' from dimension

clipboard_image_0.png

clipboard_image_1.png

 

i have try  'Include zero values' , but the data are not at zero.

 

I think it is continuous scale use

clipboard_image_2.png

but the graph look like this :

clipboard_image_3.png

 

Sophie

_armoco_
Partner - Creator II
Partner - Creator II

Hi,

Have you created a master calendar? A master calendar will generate all the dates even if dates are missing from you data. That way your graph will be continuous. 

Example:

Your data has dates: 01/04/2019, 03/04/2019, 06/04/2019

Calendar will generate: 01/04/2019, 02/04/2019, 03/04/2019,04/04/2019, 05/04/2019, 06/04/2019

 

Regards,

Arjun

sophie_bd
Partner - Contributor III
Partner - Contributor III
Author

Hello,

yes i have a master calendar with the dates.

With my selection some dates haven't got data, so i want to have a continous axe.

 

Sophie