Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

QSense
Contributor II

count for current year

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

1 Solution

Accepted Solutions
krishnacbe
Valued Contributor III

Re: count for current year

Try this

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

6 Replies
krishnacbe
Valued Contributor III

Re: count for current year

Hi

Hope below expression will help you

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

Regards

Krishna S

QSense
Contributor II

Re: count for current year

What do you count here There is no ID statement

krishnacbe
Valued Contributor III

Re: count for current year

Try this

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

Not applicable

Re: count for current year

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
Contributor II

Re: count for current year

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

Not applicable

Re: count for current year

Then how about using 'set' in the expression

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

Community Browser