Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

amit_saini
Honored Contributor III

Sorting Help???

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

6 Replies
jaaldurgam
Valued Contributor

Re: Sorting Help???

Hi Amit,

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

Happy to help

Sreeni

amit_saini
Honored Contributor III

Re: Sorting Help???

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

Re: Sorting Help???

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

jaaldurgam
Valued Contributor

Re: Sorting Help???

Amit -

Convert your date as

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

then apply sort on this..

Sreeni

MVP
MVP

Re: Sorting Help???

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
Honored Contributor III

Re: Sorting Help???

JD ,

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

Thanks,
AS

Community Browser