topic Re: rename value in QlikView

rename value

EllenBerden — Sat, 16 Nov 2024 17:40:09 GMT

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?

Re: rename value

Anil_Babu_Samineni — Mon, 28 Dec 2020 15:38:10 GMT

check once : https://help.qlik.com/en-US/sense/November2020/Subsystems/Hub/Content/Sense_Hub/Scripting/null-value-handling.htm

Re: rename value

marcus_sommer — Tue, 29 Dec 2020 11:22:34 GMT

Maybe with:

if(value = 0, null(), value) as value

- Marcus