# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

#### Breathe easy -- you now have more time to plan your next steps with Qlik! QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Valued Contributor II

## why count expression need to use AddYears ?

Hi All

Table 1 expression return correct value on count no of company :-

Count(distinct{\$<year = {\$(=Max(year)-0)}, date = {"<=\$(=Date(AddYears(Max({<year={\$(=Max(year))}, sales = {'*'}>} date), -0)))"}, month>}company)

Table 2 expression return correct value on compute sales :-

Sum({\$<year = {\$(=Max(year)-0)}, month = {"<=\$(=Max({<year={\$(=Max(year))}, sales = {'*'}>} month))"}>}sales/\$(Columndim89)/1000)

Does any one know why table 1 count expression need to use AddYears ?

Paul

4 Replies MVP

## Re: why count expression need to use AddYears ?

For table 1, the expression which is enabled is the second one, which is this:

=count({\$<year = {\$(=max(year))},month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}, company= {'=sum({\$<year = {\$(=max(year))}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>} sales)>1'}>} distinct company)

When I enable the AddYear expression, I get a count of 9. Not sure which one is correct.

Valued Contributor II

## Re: why count expression need to use AddYears ?

Hi Sunny

Below both expression work :-

count({\$<year = {\$(=max(year))},month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}, company= {'=sum({\$<year = {\$(=max(year))}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>} sales)>1'}>} distinct company)

Count(distinct{\$<year = {\$(=Max(year)-0)}, date = {"<=\$(=Date(AddYears(Max({<year={\$(=Max(year))}, sales = {'*'}>} date), -0)))"}, month>}company)

But when i see you did count by invoice , the expression you share with me is below :-

Count(distinct{\$<year = {\$(=Max(year)-0)}, date = {"<=\$(=Date(AddYears(Max({<year={\$(=Max(year))}, sales = {'*'}>} date), -0)))"}, month>}inv)

So i conclude that above first expression is not require. As it is very complicated.

Then i just wonder why Count by coy or invoice need to use AddYears ?

Paul MVP

## Re: why count expression need to use AddYears ?

I am confused Paul You are asking why Count(inv) works with AddYears and other one doesn't? Is that your question?

Valued Contributor II

## Re: why count expression need to use AddYears ?

Hi Sunny

My question is not count(INV) use addyears and why count(coy) don't .

My question is why count use Addyears and why compute sum(sales) don't use Addyears ?

Paul

Sent from my iPhone

Community Browser