topic Compare year values from two columns in QlikView

Compare year values from two columns

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

Hi,

I have a requirement to compare year values from two columns for a chart. i tried using the below but its not working.

count({<[Year of Expense]={"=[Year of Expense]=[Scheduled Year]"}>} Status)

Any help is much appreciated. Thanks!

sunny_talwar — Fri, 09 Dec 2016 14:18:10 GMT

May be this:

Count({<UniqueIdentfier = {"=[Year of Expense]=[Scheduled Year]"}>} Status)

Here replace UniqueIdentifier with a field that uniquely identify each single row of your table

Anonymous — Fri, 09 Dec 2016 15:00:52 GMT

Thanks a lot..