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 · Accepted solution]

Hi Deepak,

I've made similar application. In my example i have a pivot table with two dimensions and i sort an expression by using Rank function.

I hope this will help you.

Milda

[deepakk]

Superb... Txxxxxx....Milda...!!!!

[#4]

Hi Milda!

Really Awesome! Very Very useful one. I was also looking for the same one and got the perfect solution. If you have any more sample document please upload it. It will help us!

Very nice script also!!!

Thanks and Regards,

Rikab

[#5]

Hello Milda!

How to do other way!

I want to Display Customer who are not there in Previous year top 100 and there in current year top 100... What changes are required in the script! Will be much thankful to you if you can explain how the script works also. As i am very new to qlikview scripting!

Thanks and Regards,

Rikab

[#6]

Hello Deepak!

Hope you can also help me out here if you can understand the script!

Regards,

Rikab

[deepakk]

HI dsJain,

Whats Your name ? I hope the attach application will help you.

I have added your require report in milda's application.

[deepakk]

Rikab,

Hope the application helps you out.

[#9]

Hello Rikab,

as you see Deepak has already made a perfect new report in my application as you required.

The script is very simple. There is a possibility to load data whitch you write straight to the script (not from a file). So you can write LOAD * INLINE .....

or just use an "Inline Wizard".

Milda

[#10]

Hi Deepak!

Thanks for replying me. I were already used the same script like yours before but it is not working in my document though it is true that it is working in milda's document. Not sure too sure where we i am going wrong.

Please check the same in the attached document and give me solution for this problem if you can.

To open the document use userid: 0010012021, password: c2info99

Something strange is happening in my document. When i load all the data it is showing correctly. But when login and see it is not show correctly. Don't have any clue what wrong!

You can see from the below image that though items were missing it is not showing here.

Thanks and Regards,

Rikab