logical expressions working for 'AND' operator

Fri, 13 Apr 2012 10:36:36 GMT

I have a IF expression like IF(condition a AND condition b AND condition c AND condition d AND condition e, reportId,'N/A').

In condition I am comparing a variable with a column like

condition a 😆 createDate >= CalenderDate(column from one of my table)

condition b 😆 createDate <= CalenderDate(column from one of my table)

What I observed that rows having createDate is NULL in database but satisfying the condition c,d,e are displaying in my result. My assumption for logical expression is NULL >= CalenderDate will return FALSE and therefore the whole expression will return FALSE adn finally the IF expression should display 'N/A'.

It should operate internally like

IF(FALSE AND TRUE AND TRUE AND TRUE AND TRUE,reportId,'N/A') => If(FASLE,reportId,'N/A') => N/A

Re: logical expressions working for 'AND' operator

swuehl — Fri, 13 Apr 2012 13:35:01 GMT

I tried to reproduce what you've observed but failed to do so.

Maybe you could check my attached sample and update to your setting or create your own sample?

BTW, on what version are you? I checked QV9 and 11.

Regards,

Stefan

topic Re: logical expressions working for 'AND' operator in QlikView

logical expressions working for 'AND' operator

Re: logical expressions working for 'AND' operator