Bar Chart Sorting issue

Fri, 01 Jul 2011 15:46:27 GMT

I have a bar chart that depicts the close ratio for each GEO over the past 12 months. The formula is calculating the close rate correctly, and depicting it correctly, but I can't get the sort order to work. I am displaying these rates over a field called NumFYMonth. This is just a formula within the script that merges the FY number and the month number. I need this to sort by month within fiscal year, and then by fiscal year, but I can't seem to get it to work. Any help would be appreciated. Right now it is sorting largest to smallest because it is taking the FYMo number as a whole number 201112 instead of 2011 12. So, I just need help figuring out how to get it to ignore this number and sort the way that I want it to.

Thanks

Re: Bar Chart Sorting issue

nagaiank — Fri, 01 Jul 2011 16:19:39 GMT

Either format your NumFYMonth in the pattern YYYYMM or you may use the calculated dimension in the chart with the expression

=Left(YM,4) & Num(Mid(YM,5),'00')

and set the sort order to 'Numeric Value Ascending'

Hope this helps.

topic Bar Chart Sorting issue in QlikView

Bar Chart Sorting issue

Re: Bar Chart Sorting issue