topic Problem in sorting Fiscal month in QlikView

Problem in sorting Fiscal month

Tue, 09 Sep 2014 07:02:15 GMT

Hi all

In a line chart i want to sort month from april to march

X axis - month

Y axis(Sales)=Sum({<SALES_DATE=,YEAR=,MONTH=,QUARTER=,FiscalYear=,WEEK=>}NET_AMOUNT)

I used Sort expression like this for sorting in sort tab--> expression

=Match(MONTH,'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar')

I am not using master calendar but i am using calender object for date(SALES_DATE)

My problem is when there is no date selected in calender object its working fine(Fig1).But its not working when some date is selected(Fig 2)

I dont know whats happening.

Can anyone help me how can i solve this

Re: Problem in sorting Fiscal month

Tue, 09 Sep 2014 07:07:52 GMT

go to chart properties and under sort tab click on dimension month and uncheck all the sort order and check Load order option,this will sort your month correctly

Re: Problem in sorting Fiscal month

Tue, 09 Sep 2014 07:13:37 GMT

Hi Bhawna

Its not working.

Re: Problem in sorting Fiscal month

Tue, 09 Sep 2014 07:24:32 GMT

Anyone pls Help me to solve this

Re: Problem in sorting Fiscal month

Tue, 09 Sep 2014 07:41:41 GMT

Not only calendar date even when i select month or quarter also its not working

Re: Problem in sorting Fiscal month

israrkhan — Tue, 09 Sep 2014 07:44:03 GMT

i think you have to use pick() function with match()..

like below

Pick(Match(MONTH,'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar'), 1,2,3,4,5,6,7,8,9,10,11,12)

or second option is , generate a table in script like below..

load * Inline [

MONTH, Number

Apr,1

May,2

Jun,3

Jul,4

Aug,5

Sep,6

Oct,7

Nov,8

Dec,9

Jan,10

Feb,11

Mar,12

];

it will link automatically to your month field, and than in the sort table, sort it as "Numeric value"

hope it helps...

Re: Problem in sorting Fiscal month

aveeeeeee7en — Tue, 09 Sep 2014 07:48:26 GMT

Use this Expression:

=Dual(MONTH,Match(MONTH,'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar'))

Regards

Aviral Nag

Re: Problem in sorting Fiscal month

Tue, 09 Sep 2014 08:01:31 GMT

Thank you all for your help

I dont know what the problem is but i fixed the problem by using alternate state so it remains same whatever i select.

Re: Problem in sorting Fiscal month

Charlie007 — Thu, 19 Oct 2023 05:37:36 GMT

Please share the solution of this issue as I am facing same problem when the data of future period does not exist. I am waiting for your reply and hope to receive it soon.