IFERROR Excel formula to Qlik Sense

[iris82]

Hi all,

I have stuggleing with the below function:

sum(aggr(sum(DISTINCT ([qty])/([unitsן]*[car]*[layers])),item,[month]))

I would like to add to above function that if the units are NA-->pls give me 10 units (iferror function in excel)

f the car are NA-->pls give me 10 car (iferror function in excel)

f the layers are NA-->pls give me 7 layers (iferror function in excel)

Thanks a lot!

[Rohan]

Hi,

you can use exactly that in the load srcipt :

if(isnull(Units) or wildmatch(Units,'NA'),10,Units) as "new Unit",

if(isnull(cars) or wildmatch(cars,'NA'),10,cars) as "new cars",

if(isnull(layers) or wildmatch(layers,'NA'),10,layers) as "new layers"

Use these new fields in that formula so that other areas are not impacted..