How to find newly added customer yearly ?

[shekhar_analyti]

Hi All ,

How to find newly added customer sales ?

My Requirement :

Issue :

Thanks & Regards

Shekar

[Chanty4u]

try

Firstsortedvalue(Dim,-Year)

[shekhar_analyti]

please attach qvw

[Chanty4u]

sorry i dont have license version

[sunny_talwar]

May be this

Sum({$<CustomerID = e({1<Year_of_Sales={2014, 2015}>})>} Sales)

[shekhar_analyti]

Hi Sunny ,

Here are my few doubts ..

1) customer 279-01-1655 is newly added in 2016 , it should not be there in 2017 as its returning customer

2) In the set expression we are passing values 2014,2015 manually . what If my data is dump of 20 years and every year in need to see my new customers , is there any dynamic way ?

Thanks & Regards

Shekar

[sunny_talwar]

1) Exclude 2017 in your expression also

Sum({$<CustomerID = e({1<Year_of_Sales={2014, 2015, 2017}>})>} Sales)

2) There should be, but might need use of The sortable Aggr function is finally here!... do you have QV12 or above?

[shekhar_analyti]

Hi Sunny ,

I do not have QV 12 but if you can give me Qlik 12 qvw , i can still see the solution .
Actually i have dump of 20 plus years and hence i needed an expression which should show me number of returning customers and their sales vs newly added customer sales ....

Thanks & Regards

Shekar

[sunny_talwar]

And you want to sum the sales of new customers each year which don't have any sales before or after that year where year is the dimension, right?

[shekhar_analyti]

i want sales of all those customer which appeared for first time .
For example if i am doing purchase from alibaba for first time in year 2017 , then  i am new customer . however i can still do some purchase in year 2018 , 2019 .. but in that case i am a returning customer ...

so my requirement was something like year should be dimension . something like this ;

Thanks & Regards

Shekar