topic Re: Expression error in QlikView

Expression error

Sun, 09 Feb 2014 19:03:03 GMT

Hi!

Can you maybe help me to correct this expression pls?

=count(DISTINCT(count(distinct{$<Year ={2010}, Month =
{'11','12'}>} Name)+count(distinct{$<Year ={2011}, Month = {'1','2','3'}>} Name)))

I want to count the number of the names from 11/2010 to 3/2011. But I dont know how to write this expression without count two times the same name in this period.

Any suggestions greatly appreciated.

Andrea

Re: Expression error

swuehl — Sun, 09 Feb 2014 19:29:34 GMT

Maybe like this:

=count( {$<Year ={2010}, Month ={'11','12'}>+<Year ={2011}, Month = {'1','2','3'}>} Name)

Or select the range on a YearMonth field, maybe with a search expression like

=count( {$<YearMonth= {">=201011<=201103"}>} Name)

Re: Expression error

Sun, 09 Feb 2014 22:21:09 GMT

Thank you so much for ypur help!