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.

[sunny_talwar]

Isn't how this is sorted right now in your sample?

[Chanty4u]

did u tried here?

[Chanty4u]

orelse

use sort tab-->expression like

Match(Field,'jan','feb',..............)

[suvechha_b]

No Check the Full Year Chart

Planning Month

Apr coming after Dec.

[amit_saini]

Hi ,

Try something like below as Expression :

Dual(Month,Match(Month,'jan','feb','mar','apr','may','jun','jul','aug','sep','oct','nov','dec'))

Thanks,

AS

[suvechha_b]

Didn't work

[suvechha_b]

Didn't work

[suvechha_b]

Didnt work.

[#10]

Just promote (use Promote button) Planning Month over RO in "Sort" tab and you will have correct result on your Full Year chart. Take a look at attachement.