Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to sort the months according to the name ?

How to sort the months according to the name ?

2 Replies
mjayachandran
Contributor II

Re: How to sort the months according to the name ?

= match([XYZ Month],'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'))

you can put the months in any order

Re: How to sort the months according to the name ?

Hi,

use this expression under sort

Dual("Your Month Field",match("Your Month Field" ,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'))

Check this

I want to arrange date in order of ascending order

Regards

ASHFAQ

Community Browser