Iam new to qlikview and trying to Create Dash bord with Same Excel data.
i have column called Month-Year having data like (Jan 2013) i want to bring only Month Name and want to use that in X-axis .
I mean it as to show Only month Names on X-axis.
If you have field MonthName eg. Jan 2012, Feb 2014, Mar 2013, etc
than you can use following options in your chart:
1) SubField(MonthName,' ',1)
or use it in your script:
SubField(MonthName,' ',1) AS Month