Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
pennetzdorfer
Creator III
Creator III

Equivalent to IFERROR function in Excel?

Hey,

is there a Qlikview-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.

In Qlikview you need to do something like

if(isNull(value_expression), value_if_error, value_expression)

Or am I missing something?

Regards,

Florian

1 Solution

Accepted Solutions
oscarmqz
Creator III
Creator III

Hi Florian,

     Maybe it's too late, but I had the same problem and just found the solution today. The "Alt" function, you can add as many formulas as you want, the result is the first one (from left to right) that return a valid numeric value.

ALT(9/0,0)

Would return 0, because of the division by zero returns a dash "-"

View solution in original post

4 Replies
oscarmqz
Creator III
Creator III

Hi Florian,

     Maybe it's too late, but I had the same problem and just found the solution today. The "Alt" function, you can add as many formulas as you want, the result is the first one (from left to right) that return a valid numeric value.

ALT(9/0,0)

Would return 0, because of the division by zero returns a dash "-"

View solution in original post

Not applicable

Florian,

I do not know such a function.

If you want to reuse several times a function, you may use the preload technique. You will have 2 consecutive LOAD statements, and only the first one will populate the table. Take care, the LOAD which populate the table is the 1st one, and the second load is the one that will be source of the 1st !!

LOAD if(isnull(A/B), A, B) as A2,

           xxxx;  (no FROM the source is the second load below !!)

LOAD MyveryDifficultFunction as A,

        MYsecondDifficultFunction as B,

  C, D, E ....

FROM xxxx;

Fabrice

pennetzdorfer
Creator III
Creator III
Author

Oscar, thanks for your solution - that helps a lot!

It's never too late to learn new Qlikview functions

Regards,

Florian

sakshikaul
Creator II
Creator II

Hi,

Please help me in writing an executable script for below given excel formula.

iferror(if(E22<>"1",((vlookup(Z22,Master!$G:$I,3,0)),"check"),"check")

I have tried writing following executable script in  qlikview :-

if(damage_tag<>1, applymap('part_no',material,'check')) as abc,

this is not giving correct result.. please help