Replace calculated values in Qlikview objects

[#1]

Hello all,

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.

Example: Bar Chart - Volume of Referrals by Organization

Each bar with value less than 5 should be replaced with 5.

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.

Thank you in advance,

Behnaz

[Clever_Anjos]

I don´t see an easy way of doing this.

Using Expression Overview, maybe you can use some Find/Replace like below

Original Expression: Sum(Value)

Replace With : RangeMin(Sum(Value),5)