Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have one extreme outlier in my datafile.
When age is unknown, my datafiles mark them down as 0. How can I recode these values into "-" or "unknown", so that they do not have an effect on my age mean?
check once : https://help.qlik.com/en-US/sense/November2020/Subsystems/Hub/Content/Sense_Hub/Scripting/null-value...
Maybe with:
if(value = 0, null(), value) as value
- Marcus