Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

arrange date in bar chart

Hi, how do I arrange the dates properly in bar chart? My current bar chart is as such:

Untitled6.png

Thanks

4 Replies
Highlighted
Champion
Champion

Re: arrange date in bar chart

right(Fieldname,4)&num(left(field,3)) in sort expression

else if you have datefield  then write down in sort express

hope this helps

Highlighted
MVP
MVP

Re: arrange date in bar chart

Create the date field using MonthName() in the script, it will get sorted properly in the front end as expected.

Load

          MonthName(DateField) as [Month Name]

Highlighted

Re: arrange date in bar chart

HI,

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.

OR

use below

=Year * 100 + Month

By this you will always have numbers that are 6 digits

ex. 201401, 201402,201303,..... and so on

OR

try with sort by this expression (in sort tab)

=Year & num(Month, '00')

Regards

ASHFAQ

Highlighted
Not applicable

Re: arrange date in bar chart

Hi

Try like this

in edit calculated dimension write

monthname(date)

Bar chart-->Properties-->Sort Tab-->Select the dimension name--> then select order as orginal

Regards

Nirmal