topic count for current year in QlikView

count for current year

QSense — Thu, 06 Sep 2012 11:40:10 GMT

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 — Thu, 06 Sep 2012 11:43:28 GMT

Hope below expression will help you

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

Regards

Krishna S

QSense — Thu, 06 Sep 2012 11:47:34 GMT

What do you count here There is no ID statement

krishnacbe — Thu, 06 Sep 2012 11:48:53 GMT

Try this

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

Thu, 06 Sep 2012 11:55:15 GMT

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 — Thu, 06 Sep 2012 11:59:45 GMT

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

Thu, 06 Sep 2012 12:03:43 GMT

Then how about using 'set' in the expression

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