Skip to main content

Qlik

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
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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 (3)
Labels
462 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

415 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
453 Views
0 Likes
marcus_sommer
MVP
MVP
‎2020-12-29 06:22 AM

Maybe with:

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

- Marcus

416 Views