Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with alignment

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?

0 Replies