topic Re: Assistance with Expression in QlikView

Assistance with Expression

QFanatic — Wed, 25 Nov 2020 16:16:04 GMT

Hello all

I am having trouble with an expression.

In my model I have a field INCIDENTOPENINGDATE which contains '2019/01/01' - it is a true date field (if I change the display format to Integer, it gives me a true date value - etc 43191)

In my expression I want to display everything that is LESS or EQUAL TO a variable - the variable is called vPrevDate and contains '2019/11/11'

My Expression currently is this...

=count({<INCIDENTOPENINGDATE ={"$(='$(vPrevDate)')"}>}distinct INC_INCIDENT_ID) and it works fine for = to, but NOT less than (obviously)

How do I change my expression to do the LESS than as well?

Unfortunately I cannot post a copy of the model, it is work related.

Thanks

Re: Assistance with Expression

Arthur_Fong — Wed, 13 Nov 2019 06:57:57 GMT

Try this:

count({<INCIDENTOPENINGDATE ={"<=$(='$(vPrevDate)')"}>}distinct INC_INCIDENT_ID) and it works fine for = to, but NOT less than (obviously)

Re: Assistance with Expression

QFanatic — Wed, 13 Nov 2019 10:09:53 GMT

It returns this...(see Attachment)

Re: Assistance with Expression

Arthur_Fong — Wed, 13 Nov 2019 10:29:44 GMT

You have a sample app?

Re: Assistance with Expression

QFanatic — Wed, 13 Nov 2019 11:01:47 GMT

I do but I am not allowed to post it, as it is work related.

Re: Assistance with Expression

MindaugasBacius — Wed, 13 Nov 2019 11:13:49 GMT

The script with dummy data:

SET DateFormat='YYYY/MM/DD';

SET vPrevDate = '2019/11/15';

tmp:
LOAD Chr( Floor(rand() * 26) + 65) as INC_INCIDENT_ID,
Date(today() + rowno()) as INCIDENTOPENINGDATE
AutoGenerate 1000;

The xpression:

=Count({<INCIDENTOPENINGDATE = {"<=$(vPrevDate)"}>}DISTINCT INC_INCIDENT_ID)

And the result in the picture: