Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
EllenBerden
Contributor
Contributor
‎2020-12-28 10:36 AM

rename value

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?

 

Labels (2)
Labels
929 Views
0 Likes
1 Solution

Accepted Solutions
marcus_sommer
MVP
MVP
‎2020-12-29 06:22 AM

Maybe with:

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

- Marcus

View solution in original post

882 Views
2 Replies
Anil_Babu_Samineni
MVP
MVP
‎2020-12-28 10:38 AM

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
920 Views
0 Likes
marcus_sommer
MVP
MVP
‎2020-12-29 06:22 AM

Maybe with:

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

- Marcus

883 Views