Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
4 Replies
IamBack
Champion
Champion

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

else if you have datefield  then write down in sort express

hope this helps

tresesco
MVP
MVP

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]

ashfaq_haseeb
Champion III
Champion III

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

Not applicable
Author

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