topic Re: Sorting Help??? in QlikView

Sorting Help???

amit_saini — Thu, 24 Sep 2015 09:55:18 GMT

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

Re: Sorting Help???

SreeniJD — Thu, 24 Sep 2015 09:59:11 GMT

Hi Amit,

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

Happy to help

Sreeni

Re: Sorting Help???

amit_saini — Thu, 24 Sep 2015 10:03:24 GMT

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,

Re: Sorting Help???

avinashelite — Thu, 24 Sep 2015 10:04:34 GMT

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

Re: Sorting Help???

SreeniJD — Thu, 24 Sep 2015 10:06:13 GMT

Amit -

Convert your date as

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

then apply sort on this..

Sreeni

Re: Sorting Help???

swuehl — Thu, 24 Sep 2015 10:10:59 GMT

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

Re: Sorting Help???

amit_saini — Thu, 24 Sep 2015 10:14:29 GMT

JD ,

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

Thanks,
AS