Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
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