Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I have a columns like Month and Sales.
I created a Bar Chart and now i am unable to show as " Jan,Feb,Mar...Dec".
I got the same in Qlikview, but not get in QlikSense.
Any one can suggest me..
@Sub2u444
You can try sort expression as =Month(Date#(Month,'MMM'))
Possibly you have not created the Month field using Month(). Try to correct it at the script, like:
Load
Month(Datefield) as Month
then it should get sorted as you desired by default.
Create Field in calendar and sort on this
If(Num(Month(DateField))>3,Num(Month(DateField))-3,Num(Month(DateField))+9) AS MonthNumber,
HTH
Vikas
In script you need to create the Month field as DUAL. Show text but sort by number. See Dual() in help.
Dual(month(MyDate), monthstart(MyDate)) as MyMonth