A Chart for the Current Year

[ben_skerrett]

Hi,

Although it seems like a simple request I have not been able to find a solution online and I am hoping someone can help.

I am trying to create a simple chart for a specific department, which shows non-conformances cost each month (from the current year).

I have managed to do the latter however we are only in February, so the chart looks terrible as there is only two months worth of data.

How do I show January to December on the X-Axis, even though there is only data available up until February (March through to December would simply show as zero).

Thanks In Advance

Ben

[Ksrinivasan]

hi,

you have to create dummy month field that has jan to dec, and coordinate with your real data table,

now you call in chart all future moth will be in X-Axis,

ksrinivasan

[ben_skerrett]

Thank you for the reply ksrinivasan.

Like most, I am relatively new to QlikSense. Could you please provide additional guidance on how to create a dummy month.

I have created a master calendar which is linked to the "Posting date".

Thanks

Ben

[Ksrinivasan · Accepted solution]

hi Mr. ben,

my data 

Load script:

Result:

After Adding Dummy date table field:

My Dummy Data:

Load Script:

Result

i hope its ok for you,

here you can replace my  Monthh field to your date filed name.

Ksrinivasan

[ben_skerrett]

Thank you so much for the help