topic Re: Set Analysis Date greater Today in QlikView

Set Analysis Date greater Today

ivandrago — Mon, 01 Feb 2016 17:16:55 GMT

Hi,

I have the attached document I am trying create an expression where it will count the PK field where the field DatePromised is greater than or equal than todays date, but the expression I have does not seem t be working?

Thanks

Re: Set Analysis Date greater Today

sunny_talwar — Mon, 01 Feb 2016 17:19:45 GMT

Try this expression:

Count({$<[DatePromised]={"=Date(Floor(DatePromised)) >= Today()"}>}PK)

Re: Set Analysis Date greater Today

sunny_talwar — Mon, 01 Feb 2016 17:21:26 GMT

Alternatively, I think it would be better to create a date field (without the time component) in the script and use that for set analysis. Something like this:

Fact:

LOAD PK,

DateEntered,

DatePromised,

Date(Floor(DatePromised)) as Date

Qty,

Area

FROM

C:\Qlikview\QVOrdersExample.xlsx

(ooxml, embedded labels, table is Sheet1);

and then your expression:

Count({$<Date={"$(='>=' & Date(Today()))"}>}PK)

Re: Set Analysis Date greater Today

ivandrago — Mon, 01 Feb 2016 17:31:26 GMT

Thanks Sunny, I was using the Date function i.e Date(DatePromised,'DD/MM/YYYY') but was not liking it.

Re: Set Analysis Date greater Today

sunny_talwar — Mon, 01 Feb 2016 17:33:06 GMT

Without Floor() you might format your date as DD/MM/YYYY, but it won't remove the time component. To remove time component from your TimeStamp Field you need to use Floor function.