Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

If condition returning an extra null record

Hi,

= if ([Date3 >= Date1 and Date3 < Date2,  [Variable1_Description])

The above if expression is returning, Variable1_Description along with a null record. Why is the null record being generated?

Kindly suggest!

Thanks!

13 Replies
m_woolf
Master II
Master II

I don't see how this expression can return anything.

How can Date3 be >= Date1 AND also be < Date1?

Not applicable
Author

= if ([Date3] >= Date1 and Date3 < Date2,  [Variable1_Description])

vinieme12
Champion III
Champion III

An example to clear your doubt

if( 10th Feb > 1st Feb and 10th Feb < 28th Feb , [Variable])

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

is it creating null values in data load or during export to excel?? where are you using this expression?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

I am using this expression in a straight table.

vinieme12
Champion III
Champion III

have you tried Checking ::Suppress when Value is Null >> in presentation tab

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
sdmech81
Specialist
Specialist

Hi ,

What if ur condition fails..U have not specified anything in else statement..

I mean ,

if ([Date3 >= Date1 and Date3 < Date2,  [Variable1_Description],what????)


Then when ur given codn fails its returning nthn..So specify what exactly u want whn condition fails in else statement..Hope I m correct and it helps



Sachin

sdmech81
Specialist
Specialist

So whr even ur if condition not satisfying it's giving blank..Plss specify tht in else as said above..

Sachin

vinieme12
Champion III
Champion III

Or do u have any calculated dimensions with Aggr ()??

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.