https://community.qlik.com/t5/Connectivity-Data-Prep/Meaningful-representation-interpolate/m-p/1956309#M11075 <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Übersetzung"><SPAN class="Y2IQFc">Hello Qlik community. I have a question. I am currently trying to map machine parameters. unfortunately there are misleading values ​​just above 0 at regular intervals which destroy the chart. How can I display the diagram in a meaningful way? Maybe normalize or interpolate? Attached is a picture of the diagram and the code. DB_m13_trend_conductivity_ch3_act</SPAN></PRE> Fri, 15 Jul 2022 08:29:23 GMT philip1 2022-07-15T08:29:23Z https://community.qlik.com/t5/Connectivity-Data-Prep/Meaningful-representation-interpolate/m-p/1956309#M11075 <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Übersetzung"><SPAN class="Y2IQFc">Hello Qlik community. I have a question. I am currently trying to map machine parameters. unfortunately there are misleading values ​​just above 0 at regular intervals which destroy the chart. How can I display the diagram in a meaningful way? Maybe normalize or interpolate? Attached is a picture of the diagram and the code. DB_m13_trend_conductivity_ch3_act</SPAN></PRE> Fri, 15 Jul 2022 08:29:23 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Meaningful-representation-interpolate/m-p/1956309#M11075 philip1 2022-07-15T08:29:23Z https://community.qlik.com/t5/Connectivity-Data-Prep/Meaningful-representation-interpolate/m-p/1956415#M11086 <P>You may exclude these values with a set analysis, like:</P> <P>sum({&lt; Value = {"&gt;=LowerLimit&lt;=UpperLimit"}&gt;} Value)</P> <P>whereby it might be more expedient to flag invalide values already within the script respectively to score them there.</P> <P>- Marcus</P> Fri, 15 Jul 2022 11:42:35 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Meaningful-representation-interpolate/m-p/1956415#M11086 marcus_sommer 2022-07-15T11:42:35Z