Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME 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