topic Show only Dimensions based on the value another Dimension and Measure in App Development

topic Show only Dimensions based on the value another Dimension and Measure in App Development https://community.qlik.com/t5/App-Development/Show-only-Dimensions-based-on-the-value-another-Dimension-and/m-p/1985551#M81363 <P>Hi.  I want to show the Measurement_Ids where the Name (Black) has a avg(DeltaE) is greater than 2.</P> <P>so this would return the 5 rows for  Measurement_Id 1315167 but not show 1315201.  any help would be appreciated.</P> <P> </P> <TABLE width="717"> <TBODY> <TR> <TD width="110">JobNumber</TD> <TD width="110">Measurement_Id</TD> <TD width="167">Name</TD> <TD width="110">avg(DeltaE)</TD> <TD width="110">Avg([Cyan 50%])</TD> <TD width="110">avg([Cyan BMG7])</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315167</TD> <TD>Black</TD> <TD>1.48629427</TD> <TD>-</TD> <TD>4.758022613</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315167</TD> <TD>Cyan</TD> <TD>1.748903155</TD> <TD>11.42338085</TD> <TD>4.758022613</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315167</TD> <TD>Magenta</TD> <TD>1.507291436</TD> <TD>-</TD> <TD>4.758022613</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315167</TD> <TD>PW</TD> <TD>1.550160408</TD> <TD>-</TD> <TD>4.758022613</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315167</TD> <TD>Yellow</TD> <TD>1.505830765</TD> <TD>-</TD> <TD>4.758022613</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315201</TD> <TD>Black</TD> <TD>2.03557229</TD> <TD>-</TD> <TD>-0.33224707</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315201</TD> <TD>Cyan</TD> <TD>1.17051959</TD> <TD>16.4804039</TD> <TD>-0.33224707</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315201</TD> <TD>Magenta</TD> <TD>1.420045495</TD> <TD>-</TD> <TD>-0.33224707</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315201</TD> <TD>PW</TD> <TD>1.377760053</TD> <TD>-</TD> <TD>-0.33224707</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315201</TD> <TD>Yellow</TD> <TD>1.281868219</TD> <TD>-</TD> <TD>-0.33224707</TD> </TR> </TBODY> </TABLE> Mon, 26 Sep 2022 17:55:35 GMT LewisRichardson 2022-09-26T17:55:35Z Show only Dimensions based on the value another Dimension and Measure https://community.qlik.com/t5/App-Development/Show-only-Dimensions-based-on-the-value-another-Dimension-and/m-p/1985551#M81363 <P>Hi.  I want to show the Measurement_Ids where the Name (Black) has a avg(DeltaE) is greater than 2.</P> <P>so this would return the 5 rows for  Measurement_Id 1315167 but not show 1315201.  any help would be appreciated.</P> <P> </P> <TABLE width="717"> <TBODY> <TR> <TD width="110">JobNumber</TD> <TD width="110">Measurement_Id</TD> <TD width="167">Name</TD> <TD width="110">avg(DeltaE)</TD> <TD width="110">Avg([Cyan 50%])</TD> <TD width="110">avg([Cyan BMG7])</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315167</TD> <TD>Black</TD> <TD>1.48629427</TD> <TD>-</TD> <TD>4.758022613</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315167</TD> <TD>Cyan</TD> <TD>1.748903155</TD> <TD>11.42338085</TD> <TD>4.758022613</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315167</TD> <TD>Magenta</TD> <TD>1.507291436</TD> <TD>-</TD> <TD>4.758022613</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315167</TD> <TD>PW</TD> <TD>1.550160408</TD> <TD>-</TD> <TD>4.758022613</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315167</TD> <TD>Yellow</TD> <TD>1.505830765</TD> <TD>-</TD> <TD>4.758022613</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315201</TD> <TD>Black</TD> <TD>2.03557229</TD> <TD>-</TD> <TD>-0.33224707</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315201</TD> <TD>Cyan</TD> <TD>1.17051959</TD> <TD>16.4804039</TD> <TD>-0.33224707</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315201</TD> <TD>Magenta</TD> <TD>1.420045495</TD> <TD>-</TD> <TD>-0.33224707</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315201</TD> <TD>PW</TD> <TD>1.377760053</TD> <TD>-</TD> <TD>-0.33224707</TD> </TR> <TR> <TD>NI_171580</TD> <TD>1315201</TD> <TD>Yellow</TD> <TD>1.281868219</TD> <TD>-</TD> <TD>-0.33224707</TD> </TR> </TBODY> </TABLE> Mon, 26 Sep 2022 17:55:35 GMT https://community.qlik.com/t5/App-Development/Show-only-Dimensions-based-on-the-value-another-Dimension-and/m-p/1985551#M81363 LewisRichardson 2022-09-26T17:55:35Z