Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Fill Null Values in Script

When I use NULLASVALUE, and select the null value as 0, the script doesn´t fill automatically the rest of the formulas that include the variable with the NULLASVALUE with the respective value? How can I fill missing values with different null values?

debito.png

debito.png

I set the null value as 0, and select for the variable 'Frecuencia Volumen´ and ´Recencia Volumen´ so if the data is missing the 'Ponderación Volumen' Should be 0.1 because the variables are 0. But the script doesn´t fill this variable with 0.1. How can I do that or fix some different values in case of null values? Thanks

Community Browser