Discussion Board for collaboration on QlikView Layout & Visualizations.
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!
Go to Solution.
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.
then use this field in your chart and sort it using numeric value.
Hope this helps you.
For time dimensions, I ussualy use sort by expression using =MAX(Date)
Thank you so much!!!
Thanks Lucian. Works great!!!
Works Great!!!! Thanks!