topic Re: nested if in QlikView

nested if

surajap123 — Fri, 02 Jan 2015 12:47:08 GMT

Hi All,

Please help me with the difference between both the expressions. Both give the same result then why additional brackets??

=IF(Name='John','Male',if(Name='Mary','Female','N/A'))

=IF(Name='John','Male',(if(Name='Mary','Female','N/A')))

Thanks!!

Re: nested if

Fri, 02 Jan 2015 12:57:40 GMT

Hi Suraj,

there is nothing to worry about that its just a way of representation, additional brackets show its a part of else.they both give same result

Re: nested if

its_anandrjs — Fri, 02 Jan 2015 13:03:20 GMT

Hi,

NO difference in the both the expression but better you can use Mapping table here instead of the if condition if it is in any chart that ok. But you can do this in any load script.

Regards

Anand

Re: nested if

ecolomer — Fri, 02 Jan 2015 13:10:45 GMT

Both are the same result the only difference are your representation

Re: nested if

surajap123 — Fri, 02 Jan 2015 13:15:24 GMT

Thanks everyone for the inputs !!