topic If-statement with Dates in QlikView

If-statement with Dates

guyvermeiren — Mon, 17 Oct 2011 15:16:22 GMT

Hello,

I'm working with 2 dates. If I add a Calculated dimension like

[SalesDocumentConfirmedScheduleLine.Delivery date]-Today() I get a perfect result in days

Now I would like to eliminate a number of records by "Suppress when Value is Null" and as expression

If([SalesDocumentConfirmedScheduleLine.Delivery date]-Today() > 0, Null())

but this doesn't -seem to work.

For alle values I get a Null()

Any suggestions ?

Thanks in advance .

Kind regards,
Guy

swuehl — Mon, 17 Oct 2011 15:23:18 GMT

I think your expression misses the THEN part, NULL() should be the ELSE part, right?

Like:

If([SalesDocumentConfirmedScheduleLine.Delivery date]-Today() > 0, [SalesDocumentConfirmedScheduleLine.Delivery date]-Today(), Null())

Hope this helps,

Stefan

guyvermeiren — Mon, 17 Oct 2011 15:29:44 GMT

Stefan,

No, it doesn't change a thing

Thanks anyway.

Guy

swuehl — Mon, 17 Oct 2011 15:34:54 GMT

Hm, should work given that at least some of your [SalesDocumentConfirmedScheduleLine.Delivery date]

values are Dates in the future (otherwise subtracting today will always be negative))

guyvermeiren — Mon, 17 Oct 2011 15:38:14 GMT

Stefan,

Correct, some dates are in the future and the standard calculation works as I already said in the first mail.

Kind regards,

Guy

swuehl — Mon, 17 Oct 2011 15:52:16 GMT

So I probably misunderstood your problem.

The above given expression is returning correct values, limited to future dates, in my setting. Please see attached.

Regards,

Stefan

guyvermeiren — Tue, 18 Oct 2011 07:07:41 GMT

Stefan,

Thanks, it works now

Kind regards,

Guy