topic Count and this Year, 2015 in QlikView

Count and this Year, 2015

knightwriter — Tue, 07 Apr 2015 12:47:37 GMT

Hi all,

Im looking to count activity types and only in 2015. What expression do I need to use? Count and InYear?

Kind regards,

Stephen

sunny_talwar — Tue, 07 Apr 2015 12:48:55 GMT

May be this:

=Count({<Year = {2015}>} [Activity Type])

HTH

Best,

Sunny

PrashantSangle — Tue, 07 Apr 2015 12:53:54 GMT

Hi,

if above not worked try with ''

=Count({<Year = {'2015'}>} [Activity Type])

Regards

buzzy996 — Tue, 07 Apr 2015 12:56:39 GMT

go with sunny suggestion.