Hi Guys - I need to show the variations in months across 5 years worth of data. So, just want to highlight which months of the year generally show the highest demand for our services. I have two dates I need to use - Request Date, and Event Date.
How can I get Qlikview to allow me to extract the month name, so I can use this in the dashboard I've developed? The script (relevant fields extracted) is as follows:
Thanks @Anil_Babu_Samineni - unfortunately it is pulling all of the dates in format MMM-YY. I just want Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec. So I can compare seasonal / monthly trends.