set analysis expression - how to..

[cafcptg2011]

Hi to everyone,

I have this tabela -> that it shows the total customers that we created in our database by year. And I need to know how many customers have sale in the same year of creation:

What I need is (on second column):

My set analysis expression is:

count({$< CreationYear = {'=CreationYear'}, Code ={"=sum({$< SalesYear={'=$(CreationYear)'}>}Qty)>0"}  >} distinct Code)

I have also attachment my qvw test file..

Could someone please help me.

Kind Regards,

CC

[sunny_talwar · Accepted solution]

May be try this

Count({$<Code ={"=CreationYear = Min(SalesYear)"}>} DISTINCT Code)

[cafcptg2011]

it's correct!! 🙂

Thank you very much for help!!