Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Amit,
Covert your month year from jan 2013 as 32013 (key) and apply sort on that.. easy
Happy to help
Sreeni
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
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
Amit -
Convert your date as
=Date(Date#(date_field,'MMM YYYY'),'MYYYY') as sort_key
then apply sort on this..
Sreeni
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.
JD ,
My issue is I don't have any date filed .
Thanks,
AS