Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
deepakk
Valued Contributor III

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

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

1 Solution

Accepted Solutions
Not applicable

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

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

49 Replies
Not applicable

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

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

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

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

Not applicable

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

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

Not applicable

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

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

Not applicable

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

Hello Deepak!

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

Regards,

Rikab

deepakk
Valued Contributor III

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

HI dsJain,

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

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

Smile

deepakk
Valued Contributor III

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

Rikab,

Hope the application helps you out.

Not applicable

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

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

Not applicable

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

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

Community Browser