I have a line chart that as a date axis but what i want to do is just show the day and the month as I have a fiscal year picker. So example 01/04 and not have 01/04/2013 and 01/04/2014. I have got =MID(Referral_Date,1,5) and this works great in a txt box but not on my line chart I get 41365 which is an excel date. Any help or guidance is much appreciated.
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
