topic Re: If condition returning an extra null record in QlikView

If condition returning an extra null record

Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: If condition returning an extra null record

m_woolf — Fri, 10 Feb 2017 18:35:58 GMT

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

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

Re: If condition returning an extra null record

Fri, 10 Feb 2017 18:38:05 GMT

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

Re: If condition returning an extra null record

vinieme12 — Fri, 10 Feb 2017 18:45:38 GMT

An example to clear your doubt

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

Re: If condition returning an extra null record

vinieme12 — Fri, 10 Feb 2017 18:46:45 GMT

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

Re: If condition returning an extra null record

Fri, 10 Feb 2017 19:02:30 GMT

I am using this expression in a straight table.

Re: If condition returning an extra null record

vinieme12 — Fri, 10 Feb 2017 19:08:49 GMT

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

Re: If condition returning an extra null record

sdmech81 — Fri, 10 Feb 2017 19:20:22 GMT

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

Re: If condition returning an extra null record

sdmech81 — Fri, 10 Feb 2017 19:24:08 GMT

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

Sachin

Re: If condition returning an extra null record

vinieme12 — Fri, 10 Feb 2017 19:28:52 GMT

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

Re: If condition returning an extra null record

Fri, 10 Feb 2017 20:43:15 GMT

Variable1_Description has a list of values. So the condition should match either of the value in list. There is no way logically this if condition can fail.

Re: If condition returning an extra null record

Fri, 10 Feb 2017 20:49:01 GMT

Suppress null suppresses other valid records

Re: If condition returning an extra null record

Fri, 10 Feb 2017 20:49:26 GMT

No aggr() used

Re: If condition returning an extra null record

sdmech81 — Sat, 11 Feb 2017 02:32:20 GMT

No wt I mean to say is..

Variable1_ discrription might be having values..But sometimes the following Statement might not be satisfied ryt (I mean date 3 might b less than date 1 like that)

Date3 >= Date1 and Date3 < Date2,

So whenever he above statement is not satisfied u should mention in if statement else it ll take blank..

Do mention tht in place of whta???? In my 1 St reply reply and try..Hope u gt

Sachin