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