count for current year

[QSense]

Hi everyone ,

I have dimension in order to show only 2012 values (=if(right(VARDIYARAP_ACILISTARIHIAYYIL_,4)=2012,VARDIYARAP_ACILISTARIHIAYYIL_))

I want count ID for 2012 values based on dimension above

[krishnacbe]

Hi

Hope below expression will help you

= count(if(right(VARDIYARAP_ACILISTARIHIAYYIL_,4)=2012,VARDIYARAP_ACILISTARIHIAYYIL_))

Regards

Krishna S

[QSense]

What do you count here There is no ID statement

[krishnacbe · Accepted solution]

Try this

= count(if(right(VARDIYARAP_ACILISTARIHIAYYIL_,4)=2012,ID))

[#5]

Since you already filtered out the 2012 dates in your dimension, I don't think you have to put another filter in your expression.

Doesn't just =Count(ID) give you correct result?

[QSense]

It is a pie chart and there is no date dimension there

[#7]

Then how about using 'set' in the expression

=Count({<right(VARDIYARAP_ACILISTARIHIAYYIL_,4)={'2012'}>} ID)