https://community.qlik.com/t5/App-Development/Based-on-Quarter-Selection-the-Previous-Quarter-of-selected/m-p/1788268#M61537 <P>Hello Experts,</P><P>I have a requirement of comparing quarters based on selection. Suppose a quarter is selected then previous quarter of selected Quarter must be calculated. I tried below, But i am stuck when the year changes , the Previous doesnot reflect properly.</P><P>I have a created QuarterNew field in this format, 20211,202012,202011,20212</P><P>created a variable as&nbsp;</P><P>vPreviousQuarter=GetFieldSelections(QuarterNew)-1</P><P>In text box, i have used this variable,'$(vPreviousQuarter)'. When we select a value in QuarterNew col as 202011, it shows me 202010 , but when i select 20211 it shows 20210, where as i should get 202012. how can i achieve this? please assist.</P> Sat, 16 Nov 2024 17:25:28 GMT sunainapawar 2024-11-16T17:25:28Z https://community.qlik.com/t5/App-Development/Based-on-Quarter-Selection-the-Previous-Quarter-of-selected/m-p/1788268#M61537 <P>Hello Experts,</P><P>I have a requirement of comparing quarters based on selection. Suppose a quarter is selected then previous quarter of selected Quarter must be calculated. I tried below, But i am stuck when the year changes , the Previous doesnot reflect properly.</P><P>I have a created QuarterNew field in this format, 20211,202012,202011,20212</P><P>created a variable as&nbsp;</P><P>vPreviousQuarter=GetFieldSelections(QuarterNew)-1</P><P>In text box, i have used this variable,'$(vPreviousQuarter)'. When we select a value in QuarterNew col as 202011, it shows me 202010 , but when i select 20211 it shows 20210, where as i should get 202012. how can i achieve this? please assist.</P> Sat, 16 Nov 2024 17:25:28 GMT https://community.qlik.com/t5/App-Development/Based-on-Quarter-Selection-the-Previous-Quarter-of-selected/m-p/1788268#M61537 sunainapawar 2024-11-16T17:25:28Z