Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
4 Replies
Highlighted
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

Highlighted
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]

Highlighted

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

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