Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik Sense date and time - all 12 months on a chart

Hi, I have a bar chart with month and amount; but the xasis has only months that has the data. How can I fix it so that it shows all 12 months? (From 2014/5 - 2015/5, for example)


I tried with the method from this blog

I put the calendar definition in the data load editor but when I reload and check the date and time section in the fields, I still don't get anything. How can I fix it?

11 Replies
Michael_Tarallo
Employee
Employee

Hi Seona, since jpe‌ is looking at your other question, I will allow him to answer in kind, as I am not sure,

Regards,

Mike

Regards,
Mike Tarallo
Qlik
Not applicable
Author

Hi Jonathan,

Sorry, let me explain more clearly. Your code in the previous response seems to have two sections; RawData and SalesData. And here's my understanding/questions:


RawData are dates with available sales data. But how can I easily put these data into the editor if there are so many of them?


Also my corresponding dimensions and measures are Month and sum(Amount), respectively. For 'SalesData:' in your code, would it be correct to put AmountData? Which ones must I customize to my dataset?


Thanks so much!