Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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