topic Re: Above function with 2 dimensions in QlikView https://community.qlik.com/t5/QlikView/Above-function-with-2-dimensions/m-p/1433471#M813824 <HTML><HEAD></HEAD><BODY><P>Hi Antonio,</P><P></P><P>Thanks for your solution.....It's working&nbsp; fine but instead of back end is this possible in front end in terms of exprssion.</P></BODY></HTML> Mon, 18 Sep 2017 11:12:46 GMT hari8088 2017-09-18T11:12:46Z Above function with 2 dimensions https://community.qlik.com/t5/QlikView/Above-function-with-2-dimensions/m-p/1433469#M813822 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a data like below......</P><P></P><P>&nbsp; </P><TABLE width="192"><TBODY><TR><TD height="20" width="64">month</TD><TD width="64">rating</TD><TD width="64">active</TD></TR><TR><TD height="20">jan</TD><TD>A</TD><TD align="right">21</TD></TR><TR><TD height="20">jan</TD><TD>B</TD><TD align="right">22</TD></TR><TR><TD height="20">jan</TD><TD>C</TD><TD align="right">23</TD></TR><TR><TD height="20">jan</TD><TD>D</TD><TD align="right">24</TD></TR><TR><TD height="20">feb</TD><TD>A</TD><TD align="right">25</TD></TR><TR><TD height="20">feb</TD><TD>B</TD><TD align="right">26</TD></TR><TR><TD height="20">feb</TD><TD>C</TD><TD align="right">27</TD></TR><TR><TD height="20">feb</TD><TD>D</TD><TD align="right">28</TD></TR><TR><TD height="20">mar</TD><TD>A</TD><TD align="right">29</TD></TR><TR><TD height="20">mar</TD><TD>B</TD><TD align="right">30</TD></TR><TR><TD height="20">mar</TD><TD>C</TD><TD align="right">31</TD></TR><TR><TD height="20">mar</TD><TD>D</TD><TD align="right"><P>32</P></TD></TR></TBODY></TABLE><P></P><P>Here each month having 4 type of ratings and their activities.</P><P></P><P>The out put which i required like below....</P><P></P><P>&nbsp; </P><TABLE width="256"><TBODY><TR><TD height="20" width="64">month</TD><TD width="64">rating</TD><TD width="64">active</TD><TD width="64">Outputresult field</TD></TR><TR><TD height="20">jan</TD><TD>A</TD><TD align="right">21</TD><TD></TD></TR><TR><TD height="20">jan</TD><TD>B</TD><TD align="right">22</TD><TD></TD></TR><TR><TD height="20">jan</TD><TD>C</TD><TD align="right">23</TD><TD></TD></TR><TR><TD height="20">jan</TD><TD>D</TD><TD align="right">24</TD><TD></TD></TR><TR><TD height="20">feb</TD><TD>A</TD><TD align="right">25</TD><TD align="right">21</TD></TR><TR><TD height="20">feb</TD><TD>B</TD><TD align="right">26</TD><TD align="right">22</TD></TR><TR><TD height="20">feb</TD><TD>C</TD><TD align="right">27</TD><TD align="right">23</TD></TR><TR><TD height="20">feb</TD><TD>D</TD><TD align="right">28</TD><TD align="right">24</TD></TR><TR><TD height="20">mar</TD><TD>A</TD><TD align="right">29</TD><TD align="right">25</TD></TR><TR><TD height="20">mar</TD><TD>B</TD><TD align="right">30</TD><TD align="right">26</TD></TR><TR><TD height="20">mar</TD><TD>C</TD><TD align="right">31</TD><TD align="right">27</TD></TR><TR><TD height="20">mar</TD><TD>D</TD><TD align="right">32</TD><TD align="right">28</TD></TR></TBODY></TABLE><P></P><P></P><P>have been tried different type of functions with combination of above but not getting proper output.</P><P></P><P>Am attaching the qvw for the same.</P><P></P><P></P><P>Thanks in advance....</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Above-function-with-2-dimensions/m-p/1433469#M813822 hari8088 2020-11-25T16:16:04Z Re: Above function with 2 dimensions https://community.qlik.com/t5/QlikView/Above-function-with-2-dimensions/m-p/1433470#M813823 <HTML><HEAD></HEAD><BODY><P>See Attachment.</P><P>Regards,</P><P>Antonio</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176913_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Mon, 18 Sep 2017 10:54:27 GMT https://community.qlik.com/t5/QlikView/Above-function-with-2-dimensions/m-p/1433470#M813823 antoniotiman 2017-09-18T10:54:27Z Re: Above function with 2 dimensions https://community.qlik.com/t5/QlikView/Above-function-with-2-dimensions/m-p/1433471#M813824 <HTML><HEAD></HEAD><BODY><P>Hi Antonio,</P><P></P><P>Thanks for your solution.....It's working&nbsp; fine but instead of back end is this possible in front end in terms of exprssion.</P></BODY></HTML> Mon, 18 Sep 2017 11:12:46 GMT https://community.qlik.com/t5/QlikView/Above-function-with-2-dimensions/m-p/1433471#M813824 hari8088 2017-09-18T11:12:46Z Re: Above function with 2 dimensions https://community.qlik.com/t5/QlikView/Above-function-with-2-dimensions/m-p/1433472#M813825 <HTML><HEAD></HEAD><BODY><P>Yes.....I got the solution .</P><P></P><P>aggr(if(RowNo()&gt;1,Above(active)),rating,month)</P><P></P><P>if i use above expression in chart it is giving correct result i need.</P></BODY></HTML> Mon, 18 Sep 2017 11:59:15 GMT https://community.qlik.com/t5/QlikView/Above-function-with-2-dimensions/m-p/1433472#M813825 hari8088 2017-09-18T11:59:15Z