topic Re: understand nested if in QlikView

understand nested if

Wed, 15 Oct 2014 20:01:44 GMT

if(isnull(ScannedSales), if(isnull(EnteredSales), 0, EnteredSales), if(isnull(EnteredSales), ScannedSales, if(EnteredSales > ScannedSales, EnteredSales, ScannedSales))) as RealSales,

Can someone please break above statement and explain how it works and what it does. thanks

Re: understand nested if

m_woolf — Wed, 15 Oct 2014 20:08:54 GMT

Maybe it will help you to see the code with indents:

if(isnull(ScannedSales),

if(isnull(EnteredSales),

EnteredSales),

if(isnull(EnteredSales),

ScannedSales,

if(EnteredSales > ScannedSales,

EnteredSales,

ScannedSales

)

) as RealSales,

Re: understand nested if

MK_QSL — Wed, 15 Oct 2014 20:09:36 GMT

if(isnull(ScannedSales), //Your First IF Start

if(isnull(EnteredSales), 0, EnteredSales), // First IF TRUE

if(isnull(EnteredSales), // First IF False (2nd IF Start)

ScannedSales, // 2nd IF TRUE

if(EnteredSales > ScannedSales, EnteredSales, ScannedSales))) // 2nd IF False with 3rd IF TRUE and FALSE)

Re: understand nested if

its_anandrjs — Wed, 15 Oct 2014 20:18:14 GMT

This will

if(isnull(ScannedSales), //If this expression true then below line checks expression for null()

if(isnull(EnteredSales), 0, EnteredSales), //For True if condition part

if(isnull(EnteredSales), ScannedSales, //For False if condition part

if(EnteredSales > ScannedSales, EnteredSales, ScannedSales) //Second nested if condition with true and false fields

) //Second If end here

) //First If end here

as RealSales,

Regards,

Anand