Iferror syntax replacement in Qliksense

[benedictine191]

Hi,

Actually Im just learning Qliksense, 

is there a Excel-equivalent to the IFERROR function in Excel ... IFERROR(value, value_if_error) ?

The main advantage: With that function you only have to write/calculate the value expression once.

my formula in excel are : 

=IF('MHS TTL'=0,IFERROR(('1st Availabilty TOTAL'/1)/'MHS TTL',0),1-IFERROR(('1st Availabilty TOTAL'/1)/'MHS TTL',0))

I read some article like using alt,

but still got 100% in the visualization

=if ([MHS TTL]=0,
alt(([1st Availabilty TOTAL]/1)/[MHS TTL],0),1-alt(([1st Availabilty TOTAL]/1)/[MHS TTL],0))

Can anyone please help me?

Thank you & Best Regards

[ajaykakkar93]

hi,

check with isnull()

[marcus_sommer]

Alt() should be the right function and will return the first numeric result. In your case it seems that the else-branch is returned with 1 - 0 = 1 because the expression within the alt() didn't returned a numeric value and the specified default-value is taken.

Just put all expression-parts as separate expressions parallel into a table-chart and should be quite obvious which ones return the expected values and which not.

- Marcus