topic Replace calculated values in Qlikview objects in QlikView https://community.qlik.com/t5/QlikView/Replace-calculated-values-in-Qlikview-objects/m-p/617161#M227476 <HTML><HEAD></HEAD><BODY><P><BR />Hello all,</P><P></P><P>I have developed couple of QVW files and I need to replace low volume numbers with x value shown in charts and tables due to privacy risk rules and policies.</P><P></P><P>Example: Bar Chart - Volume of Referrals by Organization</P><P>Each bar with value less than 5 should be replaced with 5.</P><P></P><P>One of the possible solutions is adding an extra condition to object expression. Applying this change manually would be a very time consuming as I need to update the expressions for almost 160 objects. I need to have it done soon and I wonder if there is any other way through macro or triggers.</P><P></P><P>Thank you in advance,</P><P>Behnaz</P></BODY></HTML> Sun, 09 Mar 2014 23:50:04 GMT 2014-03-09T23:50:04Z Replace calculated values in Qlikview objects https://community.qlik.com/t5/QlikView/Replace-calculated-values-in-Qlikview-objects/m-p/617161#M227476 <HTML><HEAD></HEAD><BODY><P><BR />Hello all,</P><P></P><P>I have developed couple of QVW files and I need to replace low volume numbers with x value shown in charts and tables due to privacy risk rules and policies.</P><P></P><P>Example: Bar Chart - Volume of Referrals by Organization</P><P>Each bar with value less than 5 should be replaced with 5.</P><P></P><P>One of the possible solutions is adding an extra condition to object expression. Applying this change manually would be a very time consuming as I need to update the expressions for almost 160 objects. I need to have it done soon and I wonder if there is any other way through macro or triggers.</P><P></P><P>Thank you in advance,</P><P>Behnaz</P></BODY></HTML> Sun, 09 Mar 2014 23:50:04 GMT https://community.qlik.com/t5/QlikView/Replace-calculated-values-in-Qlikview-objects/m-p/617161#M227476 2014-03-09T23:50:04Z Re: Replace calculated values in Qlikview objects https://community.qlik.com/t5/QlikView/Replace-calculated-values-in-Qlikview-objects/m-p/617162#M227477 <HTML><HEAD></HEAD><BODY><P>I don´t see an easy way of doing this.</P><P>Using Expression Overview, maybe you can use some Find/Replace like below</P><P></P><P>Original Expression: Sum(Value)</P><P>Replace With : RangeMin(Sum(Value),5)</P></BODY></HTML> Mon, 10 Mar 2014 00:13:44 GMT https://community.qlik.com/t5/QlikView/Replace-calculated-values-in-Qlikview-objects/m-p/617162#M227477 Clever_Anjos 2014-03-10T00:13:44Z