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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
KommulaRahul
Contributor III
Contributor III

I need to convert a null value to a zero in a pivot table

IMG-20230703-WA0008.jpg

IMG_20230703_211238.jpg

 I tried by using alt and len . Its not working

Is there any way to solve this at back end side. 

Actually there is no data in place of that  '-'. 

Can we resolve this. 

I mean converting null to zero even if there is no data over there

 

Labels (2)
1 Reply
MartW
Partner - Specialist
Partner - Specialist

please take a look at this help page

NullasValue and NullasNull are functions you might want to use

https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularSt...