Months Period Issue ?

[ramcena306]

Hi All,

I have a chart which shows Some period of months. The problem is when I click on some filters, the order of the months are changing.

I am not getting any idea on how trigger this. Please help... Even I can't find out where's the error is?

PFA.

Regards,

ramesh

stalwar1‌loveisfail‌sureshqv‌hhajjali‌tresesco‌jontydkpi‌kush141087‌shiveshsingh‌arvind1494‌farheenayesha‌

[ramcena306]

Unfortunately I can't share

[clovati]

TAB1_TMP:

LOAD * INLINE [

MyMonth, MyYear, Sales

    JAN, 2018, 1000

    FEB, 2018, 6000

    MAR, 2018, 2000

];

TAB1:

Load *,

If (MyMonth = 'JAN', 1,

If (MyMonth = 'FEB', 2,

If (MyMonth = 'MAR', 3

))) as OrderMonth

resident TAB1_TMP;

Drop table TAB1_TMP

[clovati]

[clovati]

I don't know why I can't attach my QWV example.

Hope this help! 🙂

[ramcena306]

Hi Cri Lovati,

Actually, I wanna do this in front end only.

[clovati]

It'll be less performing. Anyway you can create a new field where writing what I wrote in script.

[clovati]

You can also use Dual function

[boorgura]

Try using this expression in "Sort by Expression".

mid(Period,4,4) & left(Period,2)

where - Period is your dimension.

[ramcena306]

Hi Rakesh,

Not getting Required

[ramcena306]

Hi ,

it's working now, I have sorted expression like =Only({1}PERIOD_MONTH) .

Regards,

ramesh