https://community.qlik.com/t5/Reporting-Service-Alerting/Conditioning-a-dimension-mixed-on-an-expression-and-a-dimension/m-p/2119867#M624 <P>Hi all,</P> <P>I have the following problem in QlikView:</P> <P>- I created a conditional dimension in an object, which is based on <STRONG>three conditions of other dimensions</STRONG>, what works properly with a simple if(and, and, and) function.</P> <P>- to finalize my intention, I thougt I need to include another condition on top to the three existing conditions. This last condition is based on an expression which is already included in the same object as a column. This expression has values, but I just want to display the values above X (&gt;=X). If I include the condition as a fourth condition in the if() function, I get an calculation error.</P> <P>At the moment, I export the object and remove manually the the values below my threshold X. This is what I want to avoid in my final step.</P> <P>Should I create another separate if() function on top to my existing one in the conditional dimension and combine them with "and", which has a condition on my expresssion to be above the threshold? Or is there any possibility to set a condition on the whole object just to display value of the expression above the threshold?</P> <P>Thanks a lot for your help!</P> <P>BR, Bodo</P> Tue, 19 Sep 2023 08:46:42 GMT Bodo 2023-09-19T08:46:42Z https://community.qlik.com/t5/Reporting-Service-Alerting/Conditioning-a-dimension-mixed-on-an-expression-and-a-dimension/m-p/2119867#M624 <P>Hi all,</P> <P>I have the following problem in QlikView:</P> <P>- I created a conditional dimension in an object, which is based on <STRONG>three conditions of other dimensions</STRONG>, what works properly with a simple if(and, and, and) function.</P> <P>- to finalize my intention, I thougt I need to include another condition on top to the three existing conditions. This last condition is based on an expression which is already included in the same object as a column. This expression has values, but I just want to display the values above X (&gt;=X). If I include the condition as a fourth condition in the if() function, I get an calculation error.</P> <P>At the moment, I export the object and remove manually the the values below my threshold X. This is what I want to avoid in my final step.</P> <P>Should I create another separate if() function on top to my existing one in the conditional dimension and combine them with "and", which has a condition on my expresssion to be above the threshold? Or is there any possibility to set a condition on the whole object just to display value of the expression above the threshold?</P> <P>Thanks a lot for your help!</P> <P>BR, Bodo</P> Tue, 19 Sep 2023 08:46:42 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/Conditioning-a-dimension-mixed-on-an-expression-and-a-dimension/m-p/2119867#M624 Bodo 2023-09-19T08:46:42Z https://community.qlik.com/t5/Reporting-Service-Alerting/Conditioning-a-dimension-mixed-on-an-expression-and-a-dimension/m-p/2119870#M625 <P>Generally speaking, you can't directly use a measure in a dimension. Measures are calculated per set of dimension members, meaning they can't be calculated until the dimensions are known (otherwise, you'd get into a loop - recalculate dimension, then recalculate measure, ad infinitum).</P> <P>If you need a dimension that is based on a calculation, you'd typically need to use aggr() to calculate it in a predetermined way.</P> Tue, 19 Sep 2023 08:54:30 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/Conditioning-a-dimension-mixed-on-an-expression-and-a-dimension/m-p/2119870#M625 Or 2023-09-19T08:54:30Z