Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Issue - Evolution Chart - Sort by Year/Month

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...

untitled.JPG

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!

1 Solution

Accepted Solutions
sridhar240784
Contributor III

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

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

5 Replies
sridhar240784
Contributor III

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

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
Valued Contributor

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

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

Not applicable

Issue - Evolution Chart - Sort by Year/Month

Worked perfectly!

Thank you so much!!!

phcaptjim
Contributor

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

Thanks Lucian.  Works great!!!

Not applicable

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

Works Great!!!! Thanks!

Community Browser