Problem with alignment

Fri, 04 Dec 2015 10:10:32 GMT

I'm displaying the data of current year all months and December data of previous year and a year before that using the following code

=if(Headings='CY', Only({<YEAR={$(vDynamicYear)}>}[MTH_AC]),0)
+
if(Headings='CY-1', Only({<YEAR={$(vDynamicYear1) },MONTH_ABB={'Dec'}>}[MTH_AC]),0)
+
if(Headings='CY-2', Only({<YEAR={$(vDynamicYear2)},MONTH_ABB={'Dec'}>}[MTH_AC]),0)

where Headings is loaded inline. Now the problem is, using this the December data of current year is being displayed before Jan, Feb....and so on data . What should I do?

topic Problem with alignment in QlikView

Problem with alignment