topic Re: Dt in QlikView

Dt

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

Hi ALl

please find my QVW attached and Excel data

I need to show a table where the release numbers should show current month releases and release number(Fututre ReleaseNUmber) greater than than current month .

..Release number is like 17.1, 17.2...and so on which i have converted to month year date ....

My requirement is

Display current release and all future releases

Current Release = Current date between Release Start date and End Date

Future Release = Release start date greater than current date

Can please somone suggest me how do i show it ...

Thanks in advance

Re: Dt

vinieme12 — Mon, 31 Jul 2017 10:34:11 GMT

Chart 1 to show current release

Current Release = Current date between Release Start date and End Date

if(StartDate>today() and EndDate>today(),1,0)

Chart 2 to show future release

Future Release = Release start date greater than current date

if(Release >today() ,1,0)

Re: Dt

pathiqvd — Mon, 31 Jul 2017 11:17:48 GMT

I think u asked

Current Release = Current date between Release Start date and End Date,

if(StartDate<today() and EndDate>today(),1,0) maybe this is correct