topic Re: set analysis expression - how to.. in QlikView

set analysis expression - how to..

cafcptg2011 — Wed, 11 Apr 2018 11:40:55 GMT

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,

Re: set analysis expression - how to..

sunny_talwar — Wed, 11 Apr 2018 11:49:27 GMT

May be try this

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

Re: set analysis expression - how to..

cafcptg2011 — Wed, 11 Apr 2018 13:45:53 GMT

it's correct!! 🙂

Thank you very much for help!!