How to do the Sorting ?

[suvechha_b]

Hi All,

In my Chart the sorting is not happening correctly .

Please suggest.

My requirement is :

How to sort the Straight table chart accordingly.

Like :

Full Year Chart

planning Month :

Jul

Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

Apr

May

Jun

1st Half Of the Year

Jul

Aug

Sep

Oct

Nov

Dec

2nd Half of the year

Jan

Feb

Mar

Apr

May

Jun

Sample qlikvie model attached.

[Chanty4u]

Match will work

[sunny_talwar · Accepted solution]

Check the attached:

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

[#4]

Hi,

Try with Load order

see attached one

[Chanty4u]

hi bro,

i also given same answer na

[#6]

Hope, attached is what you want.

[qlikview979]

Hi

Try like this