top5

[#1]

Hi all,

Is it possible to make a text box that gives me the percentage of:

top 5 customers = (sales vs budget) last week vs this week?

kind regards

Vincent

[tresesco]

May be possible. Your sample qvw could help us help you.

[Anonymous]

Hi Vincent,

Yes that is perfecly possible.

How to do this depends on your data.

Could you maybe share a Qlikview document with some (dummy) data?

Dennis.

[#4]

Hi Vincent,

yes, it is possible.

But how to do it deppends on your data model.

And .... it will be easier to have this in chart like straight table.

regards

Darek

[#5]

It's possible to make a sample app with scrambeling my data right?

But I was thinking

num((sum({1< Year = {$(=vStaticCY)}, Week = {'$(=vStaticW)'}, Customername = {'1'} + { '2' } .... 5, } >} RevenueAmount)

/(sum({1< Year = {$(=vStaticCY)}, Week = {'$(=vStaticW)'}, Customername = {'1'} + { '2' } .... 5, } >} Budgetamount)

/((sum({1< Year = {$(=vStaticCY)}, Week = {'$(=vStaticW-1)'}, Customername = {'1'} + { '2' } .... 5, } >} RevenueAmount)

/(sum({1< Year = {$(=vStaticCY)}, Week = {'$(=vStaticW-1)'}, Customername = {'1'} + { '2' } .... 5, } >} Budgetamount),'###%')

I know some ()() are missing but this was my first idea to solve this problem

[Anonymous]

Hi Vincent,

please find the below expression for displaying the top 5 branch_code,according to sales value.

first expression will be display the top 5 branches and second expression for sales values for top 5 branches.

expression 1:

=chr(39)&Concat(if(aggr(rank(sum({<BRANCH_CODE=>} Sales_value)),BRANCH_CODE)<=5,BRANCH_CODE),chr(39)&','&chr(39))&chr(39)

expression 2:

=sum({<BRANCH_CODE={$(=chr(39)&Concat(if(aggr(rank(sum({<BRANCH_CODE=>} Sales_value)),BRANCH_CODE)<=5,BRANCH_CODE),chr(39)&','&chr(39))&chr(39))}>} Sales_value)

Thanks

SHAIK

[#7]

what do you mean with chr 39?

[Anonymous]

Hi Vincent,

  chr(39) will be return the ( ' ) single quotes.39 is ASCII value of single quotes.