Top 100 Customer who are there in previous Year not in Current Year

[deepakk]

Hi ,

I want to Display Customer who are there in Previous year top 100 and not there in currentb year top 100...

Any one has made such application then please do forward it to me.

Thanks & Regards

Deepak

[#2]

Hi Rikab,

I suggest you to read in QlikView Help about aggr() function and set analysis.

Aggr() function is usually used in calculated dimensions. And this function makes calculation over dimensions (in this case: we sum(SalValue) over itemname).

About Set analysis you should really read in QlikView help because there are a lot of examples.

Wish you luck! 🙂

Milda

[#3]

Hi Milda!

Thanks for your reply!

aggr( sum( {$<Year={$(=Max(Year)-1)}>} SalValue),itemname)

Let me know whether my understanding is correct or not. The above set analysis will list the sales value of the items for the Year(Year={$(=Max(Year)-1)})

Hope i am correct here! 🙂

Thanks and Regards,

Rikab

[#4]

Yes, you are absolutely right.

If max(Year)=2009, you will see sales of year 2008;

If max(Year)=2008, you will see sales of year 2007;

If max(Year)=2007, you will see sales of year 2006 and so on.....

[deepakk]

Hi All,

I Need a small help. I implemented the solution provided by milda in many of my Customers place. But I was not implement in a situation where I need to see on the basis of Year Month.

Please find the application in the attachment. I am not able to achieve the Top Performer who is there previous yearmonth but not in Current Year Month.

Thanks

Deepak

[#6]

Hi Milda,

This is an ultimate report. But as per me I think it is not taking care of minus values. It is taking care of positive sale value only. If the sales value are in negative it is not show in the Top 100 list.

Let me know how to do the same.

[#7]

Hi Milda,

Can you provide any sample example in case i want to see Top 100 customers those were present in last month but not present in current month.

I read your sample QVW that is working fine in case of year comparison.

Can you send me sample application or expresssion or anysuggestion on this because i am in a middle of a project to deliver this report.

you can mail me @

dushyant.ntpc@gmail.com

Waiting for your reply ,

DUSHYANT

[#8]

Hi Deepak,

Can you help me to implement same scenario in case of previous and last month .

Any sample application,

You can mail me @

dushyant.ntpc@gmail.com

Regards,

Dushyant

[deepakk]

hi ,

I am attaching a sample file for Current Month and Previous Month.

I hope this helps.

[#10]

Hi deepak,

Your application is working fine...

its really good.

use the following expression to assign the vLastmonth variable

=Year(addmonths(max(Date),-1)) & num(Month(addmonths(Max(Date),-1)),'00')

its used to go back to previous yearmonth . for ex if i click 2011 jan month, then last month will be Dec 2010.

[#11]

Hi Milda,

I am facing the same issue now, Can you explain me, how did you bring the customers who doesnt have the sale in the current year. i.e., customer sales value is 0. they not done any transaction this year. but they are top in the last year top N list.

Thanks in advance.