topic Re: Months Period Issue ? in QlikView

Months Period Issue ?

ramcena306 — Tue, 27 Mar 2018 12:36:36 GMT

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‌

Re: Months Period Issue ?

sunny_talwar — Tue, 27 Mar 2018 12:38:46 GMT

You must be using an expression for sorting... make sure to ignore selection (may be just {1}) in sorting expression

Re: Months Period Issue ?

Chanty4u — Tue, 27 Mar 2018 12:43:23 GMT

try this

=match(capitalize(only({1}MonthField)),'JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC')

Re: Months Period Issue ?

sunny_talwar — Tue, 27 Mar 2018 12:46:11 GMT

How did you get to know what the sort expression was

Re: Months Period Issue ?

ramcena306 — Tue, 27 Mar 2018 12:57:29 GMT

Hi Sunny,

I didn't get you.

Actually, it's working fine for some filters, but when I select anyone in Defect Status--The month of the order is getting wrong.

Re: Months Period Issue ?

ramcena306 — Tue, 27 Mar 2018 13:00:09 GMT

Hi Chanty,

Still getting the same..

Re: Months Period Issue ?

sunny_talwar — Tue, 27 Mar 2018 13:05:57 GMT

Are you using an expression for sorting on the sorting tab?

Re: Months Period Issue ?

clovati — Tue, 27 Mar 2018 13:12:43 GMT

In your load script you can write a new field (e.g Month_Order) If month = JAN, then 1, If FEB then 2,.... and then sort by this new field

Re: Months Period Issue ?

ramcena306 — Tue, 27 Mar 2018 13:13:54 GMT

No Sunny !

Re: Months Period Issue ?

sunny_talwar — Tue, 27 Mar 2018 13:29:44 GMT

Would you be able to share a sample to check this out?

Re: Months Period Issue ?

ramcena306 — Tue, 27 Mar 2018 13:48:29 GMT

Unfortunately I can't share

Re: Months Period Issue ?

clovati — Tue, 27 Mar 2018 13:50:05 GMT

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

Re: Months Period Issue ?

clovati — Tue, 27 Mar 2018 13:52:16 GMT

Re: Months Period Issue ?

clovati — Tue, 27 Mar 2018 13:52:57 GMT

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

Hope this help! 🙂

Re: Months Period Issue ?

ramcena306 — Tue, 27 Mar 2018 13:53:43 GMT

Hi Cri Lovati,

Actually, I wanna do this in front end only.

Re: Months Period Issue ?

clovati — Tue, 27 Mar 2018 13:55:31 GMT

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

Re: Months Period Issue ?

clovati — Tue, 27 Mar 2018 14:22:30 GMT

You can also use Dual function

Re: Months Period Issue ?

boorgura — Tue, 27 Mar 2018 14:29:54 GMT

Try using this expression in "Sort by Expression".

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

where - Period is your dimension.

Re: Months Period Issue ?

ramcena306 — Wed, 28 Mar 2018 05:47:48 GMT

Hi Rakesh,

Not getting Required

Re: Months Period Issue ?

ramcena306 — Wed, 28 Mar 2018 06:18:48 GMT

Hi ,

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

Regards,

ramesh