topic Re: how to write > expression in QlikView

how to write > expression

kunkumnaveen — Mon, 07 Aug 2017 10:08:45 GMT

Hello All,

i am trying to count only those IntermID whose VALIDTO date has to be greater than today,i tried below expression ,i am getting 0 as o/p,anything wrong with my expression.

count(DISTINCT{<VALIDTO = {'>$(=Date(today()))'}>}IntermID)

thanks

Re: how to write > expression

kunkumnaveen — Mon, 07 Aug 2017 10:10:49 GMT

Add on to above requirement

Valid date formate

Date(VALIDTO,'DD-MM-YYYY') as VALIDTO,

Re: how to write > expression

Anil_Babu_Samineni — Mon, 07 Aug 2017 10:13:29 GMT

May be this

count(DISTINCT{<VALIDTO = {">$(=Date(today(),'DD-MM-YYYY'))"}>}IntermID)

Re: how to write > expression

sunny_talwar — Mon, 07 Aug 2017 12:14:51 GMT

Or just use Date() function in the script while creating VALIDTO field like this

Script

SET DateFormat='DD-MM-YYYY';

Table:

LOAD ....

Date(VALIDTO) as VALIDTO,

...

FROM ....

and then this

Count(DISTINCT{<VALIDTO = {">$(=Date(Today()))"}>}IntermID)

Re: how to write > expression

calvin_wee — Thu, 24 Aug 2017 06:49:45 GMT

I have similar issue using the following. Any advise?

COUNT({<[Received Date]={">$(=DATE(WeekStart(today()),'DD-MM-YYYY'))"}>} [Request No])