topic Re: Ranking Year and Quarter as Dimension in App Development https://community.qlik.com/t5/App-Development/Ranking-Year-and-Quarter-as-Dimension/m-p/1672267#M50861 <P>Figured out a way to, essentially, turn this measure into a dimension in case anyone was curious:</P><P>Aggr(Max(TOTAL &lt;Company&gt; Year*4+Quarter) - Max(TOTAL &lt;Year,Quarter&gt; Year*4+Quarter) + 1, [Year], [Quarter], [Company])</P> Tue, 04 Feb 2020 17:46:07 GMT gagewhite 2020-02-04T17:46:07Z Ranking Year and Quarter as Dimension https://community.qlik.com/t5/App-Development/Ranking-Year-and-Quarter-as-Dimension/m-p/1671794#M50809 <P>Hello,</P><P>I am trying to rank the most recent year and quarter for us and our competitors so I can show trends for the most recent four quarters of data on a line chart, but cannot figure out how to make the ranking reset for each company. For example, this is what my data looks like before ranking:</P><TABLE width="561"><TBODY><TR><TD width="159">Company</TD><TD width="111">Company Owner</TD><TD width="81">Year</TD><TD width="113">Quarter</TD><TD width="97">Rank</TD></TR><TR><TD>Company 1</TD><TD>My Company</TD><TD>2019</TD><TD>1</TD><TD>&nbsp;</TD></TR><TR><TD>Company 1</TD><TD>My Company</TD><TD>2019</TD><TD>2</TD><TD>&nbsp;</TD></TR><TR><TD>Company 1</TD><TD>My Company</TD><TD>2019</TD><TD>3</TD><TD>&nbsp;</TD></TR><TR><TD>Company 1</TD><TD>My Company</TD><TD>2019</TD><TD>4</TD><TD>&nbsp;</TD></TR><TR><TD>Company 2</TD><TD>Competitor</TD><TD>2018</TD><TD>4</TD><TD>&nbsp;</TD></TR><TR><TD>Company 2</TD><TD>Competitor</TD><TD>2019</TD><TD>1</TD><TD>&nbsp;</TD></TR><TR><TD>Company 2</TD><TD>Competitor</TD><TD>2019</TD><TD>2</TD><TD>&nbsp;</TD></TR><TR><TD>Company 2</TD><TD>Competitor</TD><TD>2019</TD><TD>3</TD><TD>&nbsp;</TD></TR><TR><TD>Company 3</TD><TD>Competitor</TD><TD>2018</TD><TD>3</TD><TD>&nbsp;</TD></TR><TR><TD>Company 3</TD><TD>Competitor</TD><TD>2018</TD><TD>4</TD><TD>&nbsp;</TD></TR><TR><TD>Company 3</TD><TD>Competitor</TD><TD>2019</TD><TD>1</TD><TD>&nbsp;</TD></TR><TR><TD>Company 3</TD><TD>Competitor</TD><TD>2019</TD><TD>2</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>As you can see, the most recent quarters:</P><UL><LI>Company 1: 2019 Q4</LI><LI>Company 2: 2019 Q3</LI><LI>Company 3: 2019 Q2</LI></UL><P>I would like the ranking to behave as followed:</P><TABLE width="561"><TBODY><TR><TD width="159">Company</TD><TD width="111">Company Owner</TD><TD width="81">Year</TD><TD width="113">Quarter</TD><TD width="97">Rank</TD></TR><TR><TD>Company 1</TD><TD>My Company</TD><TD>2019</TD><TD>1</TD><TD>4</TD></TR><TR><TD>Company 1</TD><TD>My Company</TD><TD>2019</TD><TD>2</TD><TD>3</TD></TR><TR><TD>Company 1</TD><TD>My Company</TD><TD>2019</TD><TD>3</TD><TD>2</TD></TR><TR><TD>Company 1</TD><TD>My Company</TD><TD>2019</TD><TD>4</TD><TD>1</TD></TR><TR><TD>Company 2</TD><TD>Competitor</TD><TD>2018</TD><TD>4</TD><TD>4</TD></TR><TR><TD>Company 2</TD><TD>Competitor</TD><TD>2019</TD><TD>1</TD><TD>3</TD></TR><TR><TD>Company 2</TD><TD>Competitor</TD><TD>2019</TD><TD>2</TD><TD>2</TD></TR><TR><TD>Company 2</TD><TD>Competitor</TD><TD>2019</TD><TD>3</TD><TD>1</TD></TR><TR><TD>Company 3</TD><TD>Competitor</TD><TD>2018</TD><TD>3</TD><TD>4</TD></TR><TR><TD>Company 3</TD><TD>Competitor</TD><TD>2018</TD><TD>4</TD><TD>3</TD></TR><TR><TD>Company 3</TD><TD>Competitor</TD><TD>2019</TD><TD>1</TD><TD>2</TD></TR><TR><TD>Company 3</TD><TD>Competitor</TD><TD>2019</TD><TD>2</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>This way only way that ranks these appropriately is&nbsp;<SPAN>Max(TOTAL &lt;Company&gt; Year*4+Quarter) - Max(TOTAL &lt;Year,Quarter&gt; Year*4+Quarter) + 1, but I need the ranking as a dimension, not a measure. Any help is greatly appreciated!</SPAN></P> Sat, 16 Nov 2024 03:23:05 GMT https://community.qlik.com/t5/App-Development/Ranking-Year-and-Quarter-as-Dimension/m-p/1671794#M50809 gagewhite 2024-11-16T03:23:05Z Re: Ranking Year and Quarter as Dimension https://community.qlik.com/t5/App-Development/Ranking-Year-and-Quarter-as-Dimension/m-p/1672267#M50861 <P>Figured out a way to, essentially, turn this measure into a dimension in case anyone was curious:</P><P>Aggr(Max(TOTAL &lt;Company&gt; Year*4+Quarter) - Max(TOTAL &lt;Year,Quarter&gt; Year*4+Quarter) + 1, [Year], [Quarter], [Company])</P> Tue, 04 Feb 2020 17:46:07 GMT https://community.qlik.com/t5/App-Development/Ranking-Year-and-Quarter-as-Dimension/m-p/1672267#M50861 gagewhite 2020-02-04T17:46:07Z