Meaningful representation. interpolate?

[philip1]

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

[marcus_sommer · Accepted solution]

You may exclude these values with a set analysis, like:

sum({< Value = {">=LowerLimit<=UpperLimit"}>} Value)

whereby it might be more expedient to flag invalide values already within the script respectively to score them there.

- Marcus