Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.