https://community.qlik.com/t5/QlikView/Based-on-the-Measure-How-to-Select-the-dimension/m-p/2064352#M1223388 <P><SPAN><SPAN class="ui-provider gz b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak">Hello, here - for the calculation of measure CY Sales we need to use the field 'Fiscal_Year' which has data from Jan till latest month-Year available in the app and for the calculation of the measure ' Complete TGT' we need to use the field 'Year' which has data for all months from Jan to Dec since Complete TGT means Target for the whole year. These two measures are placed in a single table...so I need solution for this how to display both measures&nbsp;</SPAN></SPAN><SPAN><SPAN class="ui-provider gz b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak">dynamically according to the user selection for years -2021,2022,2023</SPAN></SPAN></P> <P><SPAN><SPAN class="ui-provider gz b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak">Eg.&nbsp;</SPAN></SPAN></P> <TABLE width="257"> <TBODY> <TR> <TD width="64">Year</TD> <TD width="73">CY Sales</TD> <TD width="120">&nbsp;Complete TGT&nbsp;</TD> </TR> <TR> <TD>2021</TD> <TD>100</TD> <TD>500</TD> </TR> <TR> <TD>2022</TD> <TD>200</TD> <TD>600</TD> </TR> <TR> <TD>2023</TD> <TD>300</TD> <TD>450</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> Tue, 25 Apr 2023 14:56:19 GMT Sunilkumar3 2023-04-25T14:56:19Z https://community.qlik.com/t5/QlikView/Based-on-the-Measure-How-to-Select-the-dimension/m-p/2064352#M1223388 <P><SPAN><SPAN class="ui-provider gz b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak">Hello, here - for the calculation of measure CY Sales we need to use the field 'Fiscal_Year' which has data from Jan till latest month-Year available in the app and for the calculation of the measure ' Complete TGT' we need to use the field 'Year' which has data for all months from Jan to Dec since Complete TGT means Target for the whole year. These two measures are placed in a single table...so I need solution for this how to display both measures&nbsp;</SPAN></SPAN><SPAN><SPAN class="ui-provider gz b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak">dynamically according to the user selection for years -2021,2022,2023</SPAN></SPAN></P> <P><SPAN><SPAN class="ui-provider gz b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak">Eg.&nbsp;</SPAN></SPAN></P> <TABLE width="257"> <TBODY> <TR> <TD width="64">Year</TD> <TD width="73">CY Sales</TD> <TD width="120">&nbsp;Complete TGT&nbsp;</TD> </TR> <TR> <TD>2021</TD> <TD>100</TD> <TD>500</TD> </TR> <TR> <TD>2022</TD> <TD>200</TD> <TD>600</TD> </TR> <TR> <TD>2023</TD> <TD>300</TD> <TD>450</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> Tue, 25 Apr 2023 14:56:19 GMT https://community.qlik.com/t5/QlikView/Based-on-the-Measure-How-to-Select-the-dimension/m-p/2064352#M1223388 Sunilkumar3 2023-04-25T14:56:19Z