Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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! Smiley Happy

Milda

Not applicable

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

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

Highlighted
Not applicable

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

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
Valued Contributor III

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

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

Not applicable

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

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.

Not applicable

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

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

Not applicable

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

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
Valued Contributor III

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

hi ,

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

I hope this helps.

Not applicable

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

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.

Not applicable

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

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.

Community Browser