Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
ramcena306
Creator II
Creator II

Months Period Issue ?

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

stalwar1loveisfailsureshqvhhajjalitresescojontydkpikush141087shiveshsingharvind1494farheenayesha

20 Replies
ramcena306
Creator II
Creator II
Author

Unfortunately I can't share

clovati
Partner - Creator
Partner - Creator

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
Partner - Creator
Partner - Creator

Capture.PNG

Capture2.PNG

clovati
Partner - Creator
Partner - Creator

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

Hope this help! 🙂

ramcena306
Creator II
Creator II
Author

Hi Cri Lovati,

Actually, I wanna do this in front end only.

clovati
Partner - Creator
Partner - Creator

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

clovati
Partner - Creator
Partner - Creator

You can also use Dual function

boorgura
Specialist
Specialist

Try using this expression in "Sort by Expression".

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

where - Period is your dimension.

ramcena306
Creator II
Creator II
Author

Hi Rakesh,

Not getting Required

ramcena306
Creator II
Creator II
Author

Hi ,

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

Regards,

ramesh