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

[joeybird]

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

[#2]

Hi,

Here is the trick  :

QlikSense Dimension: show all values like QlikView?

[joeybird]

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

[#4]

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.