Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a graph like so:
As you can see, MonthYear is displayed as YYYY-MM-DD 00:00:00. Ideally, I'd like it to be displayed as MM-YYYY. How would I do that?
Best,
Alison
Hi Sunny,
I have gotten it to work, thank you for mentioning about the continuous axis.
Appearance -> And I unchecked 'Use Continuous Scale'
May be use a calculated dimension
Date(MonthYear, 'MM-YYYY')
Hi Sunny,
Thank you for your suggestion but sadly in remains the same.
Do that in the data load editor Date(MonthYear, 'MM-YYYY')
Hello Kelly,
I have a Master Calendar that looks like so:
Please tell me where I should put the code
Are you using Continuous axis?
Hi Sunny,
Yes, I am
I know you can handle this in QlikView, but since I have very limited knowledge of Qlik Sense, I don't really know if this is possible or not.... If you can share the sample, then I can give it a shot.... But if you want to try on your end, look for a way to format the continuous dimension (if at all it is possible)
What is the table that is pictured in the chart above? That table would need to be configured and looking at your calendar you want 'MMM-YYYY' not 'MM-YYYY'.
Hi Sunny,
I have gotten it to work, thank you for mentioning about the continuous axis.
Appearance -> And I unchecked 'Use Continuous Scale'