Discussion Board for collaboration on QlikView Scripting.
Hi, how do I arrange the dates properly in bar chart? My current bar chart is as such:
right(Fieldname,4)&num(left(field,3)) in sort expression
else if you have datefield then write down in sort express
hope this helps
Create the date field using MonthName() in the script, it will get sorted properly in the front end as expected.
MonthName(DateField) as [Month Name]
I would suggest you to create a new field in your data-model like
MonthName(Date_Field) as MonthName
Then use this field in your chart as dimension, this will be properly sorted.
=Year * 100 + Month
By this you will always have numbers that are 6 digits
ex. 201401, 201402,201303,..... and so on
try with sort by this expression (in sort tab)
=Year & num(Month, '00')
Try like this
in edit calculated dimension write
Bar chart-->Properties-->Sort Tab-->Select the dimension name--> then select order as orginal