topic error in expression in QlikView

error in expression

marcorizzo — Wed, 28 Oct 2015 12:49:20 GMT

Hi.

I'm trying to write an expression like this:

=count({$<year(WEB_datainserimento)={year(Today())})>}IDWEB)

but it doesn't work.

I'm not finding the mistake.

Any suggestion ?

Thanks

Marco

sunny_talwar — Wed, 28 Oct 2015 13:43:47 GMT

May be try this:

=Count({$<WEB_datainserimento ={"=Year(WEB_datainserimento) = Year(Today())"}>} IDWEB)

vishsaggi — Wed, 28 Oct 2015 14:03:31 GMT

Hi Marco,

If this field stores the dates, why dont you create an extra field in your load script and then use that field in the expression.

Like try this.

LOAD *,

Year(WEB_datainserimento) As WEBYear

FROM <YourTableName>;

Expression:

=count({$< WEBYear = { "=year(Today())" } >} IDWEB)

Thanks,