Discussion Board for collaboration on QlikView Layout & Visualizations.
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...
Covert your month year from jan 2013 as 32013 (key) and apply sort on that.. easy
Happy to help
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.
Try like this:
Create a inline table,
LOAD * inline
and in your table:
text(Month) as Month_Name
then in the sort : sort on expression and use value
Convert your date as
=Date(Date#(date_field,'MMM YYYY'),'MYYYY') as sort_key
then apply sort on this..
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
My issue is I don't have any date filed .