Sorting Help???

[amit_saini]

Hi Folks,

I'm having sorting issue on below chart :

Result Required :  Jan 2013 Jan 2014 Jan 2015  Feb 2013 , Feb 2014 , Feb 2015 ....and so on...

Kindly help!

Thanks,
AS

[SreeniJD]

Hi Amit,

Covert your month year from jan 2013 as 32013 (key) and apply sort on that.. easy

Happy to help

Sreeni

[amit_saini]

JD,

This might help if user want to select from 2013 . In my case I'm having year starting from 2001 and user can select any year.

Thanks,

AS

[avinashelite]

Try like this:

Create a inline table,

LOAD * inline

[

Month_Name,value

Jan,1

Feb,2

Mar,3

...

..

];

and in your table:

LOAD *,

text(Month) as Month_Name

tabelname

then in the sort : sort on expression and use value

[SreeniJD]

Amit -

Convert your date as

=Date(Date#(date_field,'MMM YYYY'),'MYYYY') as sort_key

then apply sort on this..

Sreeni

[swuehl]

You need to create your Month, Month-Year etc. as dual values using QlikView date and time functions. Then the sorting will be automatically correct.

Why don’t my dates work?

Get the Dates Right

[amit_saini]

JD ,

My issue is I don't have any date filed .

Thanks,
AS