topic Re: Month year sorting order in QlikView

Month year sorting order

abc_18 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a list box for month year field in my report.

whenever I click on any particular month say 'Jan-2017' then rest of the month data is not appearing in sorting order.

I have already applied below formula

Dual(MonthYear,match(MonthYear ,'Nov-2016','Jan-2017','Feb-2017','Mar-2017','Apr-2017','May-2017','Jun-2017','Jul-2017','Aug-2017','Sep-2017','Oct-2017','Nov-2017','Dec-2017'))

after applying this formula initially its displaying in sorting order only, but after any particular month selection order is getting changed.

Re: Month year sorting order

its_anandrjs — Mon, 04 Sep 2017 07:45:47 GMT

In Sort order try with

Only(MonthYear,match(MonthYear ,'Nov-2016','Jan-2017','Feb-2017','Mar-2017','Apr-2017','May-2017','Jun-2017','Jul-2017','Aug-2017','Sep-2017','Oct-2017','Nov-2017','Dec-2017'))

Only(match(MonthYear ,'Nov-2016','Jan-2017','Feb-2017','Mar-2017','Apr-2017','May-2017','Jun-2017','Jul-2017','Aug-2017','Sep-2017','Oct-2017','Nov-2017','Dec-2017')

Re: Month year sorting order

Anil_Babu_Samineni — Mon, 04 Sep 2017 07:46:54 GMT

May be Use Only() in your statement?

Re: Month year sorting order

abc_18 — Mon, 04 Sep 2017 07:56:37 GMT

I tried using this expression, but still on selection of any particular month order is getting changed.

Re: Month year sorting order

its_anandrjs — Mon, 04 Sep 2017 08:03:52 GMT

In your load script add one table with SortOrder field which contains the numeric value in increasing order for monthnames and the Month Year field should be exactly same with your Fact table.

MonthSortOrder

Load * Inline

[

MonthYear,SortOrder

Nov-2016,1

Jan-2017,2

Feb-2017,3

Mar-2017,4

Apr-2017,5

May-2017,6

Jun-2017,7

Jul-2017,8

Aug-2017,9

Sep-2017,10

Oct-2017,11

Nov-2017,12

Dec-2017,13

];

After this in the Sorting of the field properties use this field SortOrder

Re: Month year sorting order

tresB — Mon, 04 Sep 2017 09:45:05 GMT

To avoid the selection re-ordering, try using set analysis {1} like:

Only( {1} Match(....

Re: Month year sorting order

abc_18 — Mon, 04 Sep 2017 10:00:44 GMT

Thanks a lot Tresesco...very helpful