Solved: Issue - Evolution Chart - Sort by Year/Month - Qlik Community

Report Inappropriate Content · ‎2011-12-20

Greetings!

I have the following issue...

I created a bar chart to show the evolution of ammounts in a timeline of Year-Month.

But I wasn't able to figure it out in the sort tab of the chart...

Enclosed, the screenshot of the chart...

Am pretty sure its a simple task, but I just couldn't figure it out by myself.

Standing by bulls-eye answer, as usual!

Thank you guys!

sridhar240784 · ‎2011-12-20

Hi,

If i understood your question properly, dimension which you are using is a not an numeric or date dimension.

While you create this dimension from date field, use dual() function to bind your text information with numeric value. You code should be as follows.

=Dual(Month(Trans_date)&'-'Year(Trans_date),MonthName(Trans_date))

then use this field in your chart and sort it using numeric value.

Hope this helps you.

-Sridhar

View solution in original post

sridhar240784 · ‎2011-12-20

Hi,

If i understood your question properly, dimension which you are using is a not an numeric or date dimension.

While you create this dimension from date field, use dual() function to bind your text information with numeric value. You code should be as follows.

=Dual(Month(Trans_date)&'-'Year(Trans_date),MonthName(Trans_date))

then use this field in your chart and sort it using numeric value.

Hope this helps you.

-Sridhar

luciancotea · ‎2011-12-20

For time dimensions, I ussualy use sort by expression using =MAX(Date)

Report Inappropriate Content · ‎2011-12-20

Worked perfectly!

Thank you so much!!!

phcaptjim · ‎2012-06-12

Thanks Lucian. Works great!!!

Report Inappropriate Content · ‎2012-06-12

Works Great!!!! Thanks!