topic Re: show missing column in bar chart where value is null or 0 in App Development

show missing column in bar chart where value is null or 0

joeybird — Mon, 14 Sep 2015 13:55:08 GMT

Hiya

have data similar to this

Year Month Revenue

2012 01 100

2012 02 150

2012 03 0 //show dimension even when there is no data

2012 04 350

bar chart is showing jan, feb, and april...I wish to show march to as 0 ...I have checked show null values.

this has not worked.

how is this achievable in qlik sense please

Kind Regards

Mon, 14 Sep 2015 14:17:41 GMT

Hi,

Here is the trick :

joeybird — Mon, 14 Sep 2015 14:28:30 GMT

Hiya

this does not work for me as I am using a count, not sum command

how do you get it to work for count please?

I did try a combo similar as shown in the link, but no joy

Kind Regards

Mon, 14 Sep 2015 14:44:35 GMT

I think you have to add a "calendar" to your model. Add something like this in the script for create a link bewteen your table and the "calendar".

calendar:

LOAD * INLINE [

Month, MonthName

'01','January'

'02','Febuary'

'03','March'

'04','April'

'05','May'

'06','June'

'07','July'

'08','August'

'09','September'

'10','October'

'11','November'

'12','December'

];

nota bene : I formatted the month as a string but perhaps you need a number format.