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 Milda!

I did not receive your mail yet. Requesting you to send it as a mail or attach it in the post if it is happening.

Thanks and Regards,

Rikab

Not applicable

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

Hi,

Pl refer page 353 of qv reference manual - set analysis to achieve the above ..

Best regards,

Tapas

Highlighted
Not applicable

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

Hi Tapas!

Thanks for joining in my post. I am not able to find anything like that in the reference manual which you are talking about. Can you please attach the reference manual which you are referring to or else can you copy paste those details here.

Thanks and Regards,

Rikab

Not applicable

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

Hi Rikab, I hope you have received my email. If no, tell me and I'll try again.

Not applicable

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

Hi Rikab,

I missed the applications which Milda uploaded...you are in the right track . Milda is using set analysis in the expression to achieve the above. Am I right Milda ?

rgds

tapas

Not applicable

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

Hi Rikab,

Thanks...the application uploaded by Milda is on right track . Set analysis is being used in the expression ..I missed the uploaded application.

rgds

tapas

Not applicable

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

Hi Tapas!

That's ok what i want to how it has been given in the reference manual. It will be helpful for me to learn many other things.

Regards,

Rikab

Not applicable

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

Hi Rikab,

my email tapasmaj@gmail.com ,... let me know your email address.. I will mail you the documentation on set analysis which I have .

rgds

tapas

Not applicable

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

Not applicable

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

Hi Milda!

That was a gr8 effort from you. It works perfectly! Coming back to your earlier post i have doubts on expression which you have used. Hope you will help me !

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Hi Rikab,

The hole expression is quite simple. I sum(values) and then use rank() function to sort the result from biggest to smallest. Then (if I want top 10) I show only these rows where the rank() <=10. I am able to understand the what sum(sales) and rank() does. But it will be helpful for me if you can explain me with your expression.

aggr function creates lots of confusion for me. I am not able to understand how it works. I also checked that with the reference manual but it is not helping me.

=IF(
aggr(
rank(total
aggr( sum( {$<Year={$(=Max(Year)-1)}>} SalValue),itemname)
,0,1)
,itemname)
<=10,

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



The first version of my formula was not quite good because it worked only with these items, which were in boath years ( if they were and in 2008 and in 2009). But the problem was with new items: the items which appeared only in 2009, and wasn't in 2008. So for this reason i used IsNull() function to test if the item is new.

Hope this will be helpfull and understandable Smiley Happy

Milda

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Rest of the things i will get cleared after the basin part is cleared!

Thanks and Regards,

Rikab

Community Browser