topic Re: Syntax issue? in QlikView

Syntax issue?

cbaqir — Wed, 18 Nov 2015 22:26:38 GMT

Hi QV Community...

I am trying to understand why this works:

round(Sum({$<FISCAL_YEAR=>}FCST_AMT), 1000)/1000

But this doesn't:

round(Sum({$<FISCAL_YEAR=,APP_DATE={">$(=today())"}>}FCST_AMT), 1000)/1000

I want the same data but only if APP_DATE is greater than today. The data is valid in my dataset.

Thanks,

Cassandra

swuehl — Wed, 18 Nov 2015 22:29:04 GMT

Have you ensured that today() returns a date format that matches the format of APP_DATE?

Maybe you need to format the result of today() using Date() function.

cbaqir — Wed, 18 Nov 2015 22:33:14 GMT

Thanks. So what would that syntax look like?

round(Sum({$<FISCAL_YEAR=,APP_DATE={">$(=date(today(), 'MM-DD-YYYY'))"}>}FCST_AMT), 1000)/1000

petter — Wed, 18 Nov 2015 22:36:02 GMT

Round(Sum( {$<FISCAL_YEAR=,APP_DATE={">$(=Num(Today()))"}>} FCST_AMT ) , 1000 ) / 1000

Turns the Today() into a date serial number which should be safe from formatting issues....