topic Re: Issue - Evolution Chart - Sort by Year/Month in QlikView

Issue - Evolution Chart - Sort by Year/Month

Tue, 20 Dec 2011 14:31:11 GMT

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!

Re: Issue - Evolution Chart - Sort by Year/Month

sridhar240784 — Tue, 20 Dec 2011 14:57:06 GMT

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

Re: Issue - Evolution Chart - Sort by Year/Month

luciancotea — Tue, 20 Dec 2011 15:04:31 GMT

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

Issue - Evolution Chart - Sort by Year/Month

Tue, 20 Dec 2011 16:17:55 GMT

Worked perfectly!

Thank you so much!!!

Re: Issue - Evolution Chart - Sort by Year/Month

phcaptjim — Tue, 12 Jun 2012 12:28:48 GMT

Thanks Lucian. Works great!!!

Re: Issue - Evolution Chart - Sort by Year/Month

Tue, 12 Jun 2012 12:49:20 GMT

Works Great!!!! Thanks!